Context Transition in Power BI and Tricky Examples

thank you sir

Hi, I have a question, is context transition somewhat similar to "Group By" in Power Query?

Perfect. It helped me to know that every measure is wrapped around an implicit invisible CALCULATE function in Dax. That's why writing only SUM will not give the same result, you are not writing the same measure, because every measure starts invisibly with CALCULATE 😊😊 love your videos, they help me out a lot, thanks❤

Brother..no word to admire your explaning DAX..it is really final DAX destination...believe me it is coming from my heart....Bhai...your examples literally leave no confusion to understand DAX....I joined class and see explanation difference.........God Bless You bro...🙏🙏🙏🙏🙏🙏

Brilliant video AS ALWAYS!
I was just wondering if values(calendar[date]) could be replaced by values(sales[orderdate]). Is this makes any sense? And why/why not is necessary to use the function "related" when using a column of another table (in this case the calendar date). Hope you answer my question(s), many thanks!

Brilliantly explained with tricky examples nitty gritty of context transition

im searching for the data model you used in the video. couldnt find it

Do I used mention trick for max Sales made by salesman in power query

Nice explanation!

very good explanation !

If a person has basic understanding of DAX, then I wud highly recommend to attend his course or vdos watever suits uhh... Because this person is teaching DAX with such a simple explanation. Big fan of Mr Chandeep.

Simply Amazing ,Even Some Experienced people fail to explain the way you explained.

Wow !.. I have watched other context transition videos BUT i only understand now through your explanation.. very clear with examples/illustrations.... thank you very much ! I clicked then the subscribe button :)

Awsomeeeeeeeeeeeeee!!!!!!!!!!

Awesome 👍👍👍

Excellent!! The clearest explanation of iterator functions.

Great

Wow Finally understood this 😮❤

Everybody is different, but your teaching style lines up perfectly with my learning style and has been a great help to me. Thanks for your hard work Chandeep!

Great explanation

Many thanks for putting together this video. I find it very helpful. Your explanation of the definition of context transition and how it works when using the actual calculation and the measure in the iterator calculations made so much sense. You also have made it clear and easy to understand by demonstrating how it works in two simple examples. Thank you (❁´◡`❁)

good explanation .......bro

easy to understand. thanks goodly

Great explanation.. Keep it up 👍👍👍

Awesome. Thank you Bro for explaining the concept...🙂

Best explanation on the subject I've seen 👍

nice explanation

The only video i ever played on 0.75. And vola 70 precent of dax is done i guess

Bhainl tu toh dev maush hai

Great explanation, simple examples, bravo! While watching this I understood that i had already used this concept intuitively but didn’t fully understand how it worked 😂

Finally a clear explanation of what context transition means. Thank you, subscribed to your channel.

Thank you, sir.

I really loved your explainations, especially on that ticky concept of context transition. Bravo !

Thanks for your help

How do you prepare pivot table in Power BI

Nice Explanation

Hi sir, In this lecture you told to create the virtual table using values function to get aggregated sales per day with the distinct Calender Date. But that virtual table is not in the data model so how it will change with the Initial filter context on the calender date. Please help?

Hello there!
can you show the measure for [Total Sales]
because I dont even end up to understand why using this measure works perfectly instead SUM(Sales[SalesAmount])

you will help me a lot.
grettings from Lima, Perú

I'm in awe. THE BEST explanation of context transition I've encountered so far. Bought a book, watched multiple videos but still this was very tricky to understand. I'll re-watch this video when I get confused again. Cheers!

Sir in the last can example as Context Transition was not happening bcoz of no unique key, can we use Calculate with the measure?

That's Amazing .......

I've read multiple DAX books and watched dozens of videos trying to learn context transition, and I still didn't get it, until I watched this video. You did an excellent job explaining a deceptively difficult concept. The parts where you repeated yourself actually helped a lot for me, because each time you said it the first time, I was still thinking "Ummm... I think I maybe understand it, but not sure." And then when you repeated it, I was able to compare what I thought in my head to what you were saying, and that's when it finally clicked. Some people might not like the repetition, but for me, it was absolutely necessary, and I think that might be why none of the other learning resources had managed to convey the concept successfully before now.

Thank you sir

Best explanation ever. Thanks a ton!

Very Well Explained 👌👍

Nice explanation on context transition. I think for the Best Selling Day measure instead of using values function just the calendar table will also work as it always has unique values to iterate.

amazing explanation, probably best on the whole internet

Excellent!