CONTEXT TRANSITION - the most difficult DAX concept clearly EXPLAINED

Without a clear understanding of the Context Transition, you have little chance of writing complex Measures that work.
A step-by-step tutorial with a practical example that touches also on the theory.
#powerbi #powerquery #dataanalytics #datamodeling #dax

[@pbiqueryous]

Exceptional work! Thank you for sharing!

[@Data.Analytics.Central]

Thank you very much for the feedback!

[@krishnaRaog21]

Super ....Great job ...👍

[@Data.Analytics.Central]

Thanks for the appreciation! 🤝

[@shafa7668]

Very good explanation mate , well done 👏

[@Data.Analytics.Central]

Hi Shaf. Thanks for the feedback!

[@AkshayKumar-vd5wn]

Good explanation. This is confusing because no one explains it simply, you did so.
I have one doubt.
Context transition in a measure occurs when there is a "Row context" (that is the iterator function) and a measure reference right? (Which is another measure called upon).
Only then the context transition happens successfully right?
In your case in using MAXX and the [Measure].

[@Data.Analytics.Central]

Hi Akshay, you are right

[@AkshayKumar-vd5wn]

@@Data.Analytics.Central
Thank you, you deserve the pat on the back.
How you managed to explain this in a simple manner is a testament to your skills, you should be getting paid well for this.

[@rajudasari8482]

meaning of Granularity ??

[@Data.Analytics.Central]

Granularity means at what level you analyze data for example: at year level, at month level, at day level?

[@jayantmishra4270]

In some paper they have asked
How many types of context are there in
dax ??
1
2
3
4
Which option I need to select ??

[@Data.Analytics.Central]

Hi Jayant. There are 3 contexts in DAX: Row, Query and Filter contexts.

[@AkshayKumar-vd5wn]

I would say 2 because rarely we use Query.

[@Data.Analytics.Central]

@@AkshayKumar-vd5wn Queries are useful for “visualizing” intermediary tables or results in complex measures. I use DAX Studio a lot to understand the behaviours of some measures.

[@AkshayKumar-vd5wn]

@@Data.Analytics.Central
I see. Its something that I dont come across so hence never paid much attention to it.
Looking forward to more of your videos.

[@Data.Analytics.Central]

@@AkshayKumar-vd5wn Thanks a lot for the appreciation!