Understanding context transition

[hohlick]

[MattAllington]

[MattAllington]

Here is another article that I wrote that covers a similar topic http://exceleratorbi.com.au/double-calc ... x-problem/

[hohlick]

[MattAllington]

[hohlick]

[Ilya_B]

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]

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.

[MattAllington]

[matthew]