Understanding context transition

Anything related to PowerPivot and DAX Formuale
hohlick
Posts: 11
Joined: Wed Oct 26, 2016 1:22 am
Location: St.Petersburg, Russia
Contact:

Understanding context transition

Postby hohlick » Wed Oct 26, 2016 2:17 am

Regards,
Maxim Zelensky

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Understanding context transition

Postby MattAllington » Wed Oct 26, 2016 7:34 am

Attachments
context transition.xlsx
(205.4 KiB) Downloaded 203 times
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Understanding context transition

Postby MattAllington » Wed Oct 26, 2016 1:27 pm

Here is another article that I wrote that covers a similar topic http://exceleratorbi.com.au/double-calc ... x-problem/
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

hohlick
Posts: 11
Joined: Wed Oct 26, 2016 1:22 am
Location: St.Petersburg, Russia
Contact:

Re: Understanding context transition

Postby hohlick » Thu Oct 27, 2016 2:59 am

Attachments
contect transition for Matt.xlsx
here is the file with formulas
(241.6 KiB) Downloaded 157 times
Regards,
Maxim Zelensky

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Understanding context transition

Postby MattAllington » Thu Oct 27, 2016 6:11 pm

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

hohlick
Posts: 11
Joined: Wed Oct 26, 2016 1:22 am
Location: St.Petersburg, Russia
Contact:

Re: Understanding context transition

Postby hohlick » Thu Oct 27, 2016 11:11 pm

Regards,
Maxim Zelensky

Ilya_B
Posts: 1
Joined: Sat Oct 29, 2016 12:03 am

Re: Understanding context transition

Postby Ilya_B » Sat Oct 29, 2016 12:24 am

Hello, colleagues, thank you for interesting discussion!
But there are many monents, that very unclear to me yet. Sorry for bad English, I haven't English practice for a long time, but hope that you can understand me :)

Matt, when you said that the second CALCULATE argument overwrite the context transition, you mean that it "delete" the filter context (transition context) and creates new filter context by the second argument or you mean, that second argument can complement the filter comtext, and if they are use the same columns, the second argument can overwtite it?

In other words: if i have the filter context by context transition (column 1 = 'a'; column 2= 'b') and I have the table, as result a work by second argument in CALCULATE ( column 2 = 'e'; column 2='f').
The final filter context for the first argument in CALCULATE will be ( column 1 = 'a'; column 2 = 'e'; column 2='f') or (column 2 = 'e'; column 2='f')?

hohlick
Posts: 11
Joined: Wed Oct 26, 2016 1:22 am
Location: St.Petersburg, Russia
Contact:

Re: Understanding context transition

Postby hohlick » Sat Oct 29, 2016 9:39 pm

I think I got the clue for solution of this issue, when we try to change or clear filter context on linked column in related table only, and do not
I do not sure whether my explanation is correct in terms of Query Plans or how VertiPaq works in reality, but is seems to work in calculated columns. I mean, it could be technically wrong explanation, but for now, I cannot find when my explanation do not explain :)

I want to test it on more complex models and have some reading too before place an answer here, but it'll take not much time, I think.

PS: Do you know how to intrigue someone? I'll tell you. Later. :D
Regards,
Maxim Zelensky

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Understanding context transition

Postby MattAllington » Sat Oct 29, 2016 10:34 pm


matthew
Posts: 14
Joined: Sun Apr 17, 2016 5:01 pm

Re: Understanding context transition

Postby matthew » Wed Nov 02, 2016 6:15 pm



Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests

cron