I had been reading books/blogs and looking for the videos which explains context transition. So far, no one has explained better than you. Thanks a lot for this crisp clear video on context transition.
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.
To get this concept right, it is necessary to repeat it multiple time in a video. On our part, we need to repeat the video multiple times to get it right!!!
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!
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!
I would not say it's tricky but it is conceptually correct. When one of your measures is non-iterable it does the whole calculation once and then is applied to the iterable measure, then definitely result will be wrong. Thank you for great video :)
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.
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...🙏🙏🙏🙏🙏🙏
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❤
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 :)
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 😂
This is best explained video for understanding context transition thanks I was trying to learn it since so long finally got it keep making video U will rock....
Hi Chandeep, Thanks for explaining this concept in a very easy way. I have a doubt here, why we didn't get the issue in the first example where we have multiple rows for a single date as we have in the second example.
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.
Hi Chandeep, great video. but i have one doubt here. when you refere some measure in calculated column like you did for total sales, logically it should not break down. because though u refer measure its a calc column and it should understand only row context and row context disable all active relationships for that table. i tried same now , but it's not breaking down. in video at 11:05 or so values are breaking down.could you please clarify this.
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!
@Goodly, so in the last example you showed of SUM and SUMX with SUMX doing the context transition, if I am not wrong, if we apply VALUES(Test Table) which would result in unique column values and then apply SUMX should work right?
Thanks for the wonderful explanation. I just have one question : If there was one more column added to the mocked-up data which enables each row to be uniquely identified, will we still be getting the duplicates? since only the column filter will be applied, I would expect that we would still get them. I am just a bit confused how in the second example, regarding the calculated column, each row is uniquely identified. Can you please elaborate? Thanks a lot!
In case you’re still wondering this 7m later haha, I think I can help. If you add a column that creates a uniquely identified row, it would no longer duplicate the results and you would get the correct answer. The reason is because when Context Transition happens, now the new unique identifier column will be included in the resulting Filter Context, so it won’t pull in the other rows (such as the second row with Category A) and duplicate the results. It will be filtered to that single row and thus sum appropriately.
Shouldn't the filter context of the month and year pass onto the MAXX measure and iterate only for the sales table rows which matches the month year combination.
For [Total Sales] I wonder if the SUM function would work if a RELATED(?) function was used? I’ve read that measures and CALCULATE can take into account table relationships automatically I think, so I wonder if only the measure / CALCULATE work because they are able to bring in the relationship between Calendar and Sales table, while just the SUM by itself cannot unless it’s paired with a RELATED(?) function.
Hi Chandeep, can't thank you enough for your contribution to the BI community. Your explanations are spot on and easy to understand, you are what all teachers should aspire to be. Quick question, Calculation Groups, is that part of your DAX course or have you posted a video on UA-cam about that? Will register for your course as soon as I'm able to, quantity content such as yours does need to be paid for. Keep doing what you're doing brother!!!!
Thanks Francis, I have not created an explicit video on Calculation Groups but I have used them to solve problem in various videos. I think it's time to add them to the course and make a few video exclusively on CGs. Thanks again!
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?
I had been reading books/blogs and looking for the videos which explains context transition. So far, no one has explained better than you. Thanks a lot for this crisp clear video on context transition.
100%
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.
To get this concept right, it is necessary to repeat it multiple time in a video. On our part, we need to repeat the video multiple times to get it right!!!
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!
Thanks Kaylie, glad it helped.
I made another one on Context Transition here - ua-cam.com/video/NkYwwb7I3BY/v-deo.html
Cheers
My Goodness!!! You are the master of a perfect explanation. I have been struggling with this concept for ages. Thank you so much!!!
Most tricky concept in DAX I ever felt... very well explained 👍
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!
Thanks a lot Alex
Great and elaborate yet simple enough explanation for this confusing subject. I feel like I finally have a clear idea how context transition works.
Glad that was useful 💚
I would not say it's tricky but it is conceptually correct. When one of your measures is non-iterable it does the whole calculation once and then is applied to the iterable measure, then definitely result will be wrong. Thank you for great video :)
Brilliantly explained with tricky examples nitty gritty of context transition
Excellent!! The clearest explanation of iterator functions.
By far the best explanation of the most advanced concept of DAX.
Thank you.
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.
Thanks Naman :)
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...🙏🙏🙏🙏🙏🙏
Thanks Ankush :)
Finally a clear explanation of what context transition means. Thank you, subscribed to your channel.
Glad it was helpful!
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❤
Tricky Example Number three was beautifully explained.
Best. Clearest explanation!!! Thank you!!!🎉
The best explanation I have seen so far. Thanks!!!
Simply Amazing ,Even Some Experienced people fail to explain the way you explained.
As always, an outstanding explanation.
One of the best videos on Context Transition, thanks for the explanation!!
I really loved your explainations, especially on that ticky concept of context transition. Bravo !
Glad you love them!
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 :)
Glad it was helpful! :)
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 😂
Best channel for DAX, PQ & PBI.
🙏
This is best explained video for understanding context transition thanks I was trying to learn it since so long finally got it keep making video U will rock....
amazing explanation, probably best on the whole internet
Best explanation on the subject I've seen 👍
Thanks!
Hi Chandeep, Thanks for explaining this concept in a very easy way.
I have a doubt here, why we didn't get the issue in the first example where we have multiple rows for a single date as we have in the second example.
this is insane video. Superb brother... Thanks so much for the video
Thank you so much! This is the BEST explanation. I've been struggling for a long time to understand this topic. God bless you!
Glad it was helpful 💚
Thanks. Clearly well explained. Specifically, the example on the mock up data was an ‘aha’ moment 😀
Best explanation ever. Thanks a ton!
You're very welcome!
Chandeep, you are brilliant, fantastic. Thank you so much.
A brilliant explanation. Thank you!
Thanks for the time and effort taken to explain this concept
Watched again, understanding getting better. 😊
Awesome....Your explanations is upto the mark. Please bring some more DAX challenges.
Good bless you & Cheers !!!
Glad You like it 💚
Brilliant, and very easy to understand. Thanks, it solved a big problem of today.
Excellent Content...Thank you so much for doing this
Thanks sir way of explain .keep more video on dax fundamental .
Superb explanation of Context Transition. Thank you!
Great explanation. Thank you so much!
Wohoo! Brilliantly explained bro!😎🙏
Beautifully explained. Thank you.
Love the way you explained it !!! Thank you.
Excellent, Clearly well explained.
Wow, that was an amazing lesson! Broke it down so well!
Glad you liked it!
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.
Yes💯!
Very very good explanation! Thank you...
Glad you like it 😊
Great explanation. Thanks
Hi Chandeep, great video.
but i have one doubt here. when you refere some measure in calculated column like you did for total sales, logically it should not break down. because though u refer measure its a calc column and it should understand only row context and row context disable all active relationships for that table.
i tried same now , but it's not breaking down. in video at 11:05 or so values are breaking down.could you please clarify this.
Awesome. Thank you Bro for explaining the concept...🙂
Glad you like this Jaya!
Wow Finally understood this 😮❤
Explain row level security briefly.. strong explanations, amazing and keep going👍👍
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!
Excellent lesson Chandeep
@Goodly, so in the last example you showed of SUM and SUMX with SUMX doing the context transition, if I am not wrong, if we apply VALUES(Test Table) which would result in unique column values and then apply SUMX should work right?
easy to understand. thanks goodly
Glad to hear that Teuku!
The best explanation of context transition on the whole of f***in youtube
Super explanation. One question though. Why would Giuseppe use the measure in the sumx instead of value column?
thanks a lot this was bugging me since yesterday. Finally found an apt explanation.
Great explanation.. Keep it up 👍👍👍
Thank you!
The last example I had in my work today was exactly like this one!
Thanks for the wonderful explanation. I just have one question : If there was one more column added to the mocked-up data which enables each row to be uniquely identified, will we still be getting the duplicates? since only the column filter will be applied, I would expect that we would still get them. I am just a bit confused how in the second example, regarding the calculated column, each row is uniquely identified. Can you please elaborate?
Thanks a lot!
In case you’re still wondering this 7m later haha, I think I can help. If you add a column that creates a uniquely identified row, it would no longer duplicate the results and you would get the correct answer. The reason is because when Context Transition happens, now the new unique identifier column will be included in the resulting Filter Context, so it won’t pull in the other rows (such as the second row with Category A) and duplicate the results. It will be filtered to that single row and thus sum appropriately.
Nice explanation!
Great explanation
Very Well Explained 👌👍
Thank you!
Very well explained many thanks
Glad it was helpful!
Genial, esos ejemplos bastante ingeniosos, especialmente el último
¡Me alegro de que haya ayudado!
very good explanation !
But still can not understand at 02:08 why max number 3,578.27 is unified for all months?
Same here
Shouldn't the filter context of the month and year pass onto the MAXX measure and iterate only for the sales table rows which matches the month year combination.
Crystal clear!
Amazing explaination ! Thanks
Glad you liked it
No one explained so explicitely. The value of the row becomes a column filter..........
Great explanations! Thanks!
Great explanation as always...
Perfectly put. 👍
For [Total Sales] I wonder if the SUM function would work if a RELATED(?) function was used? I’ve read that measures and CALCULATE can take into account table relationships automatically I think, so I wonder if only the measure / CALCULATE work because they are able to bring in the relationship between Calendar and Sales table, while just the SUM by itself cannot unless it’s paired with a RELATED(?) function.
Thanks its clear sum and sumx difference
Thanks For the video. How can I get the data set that you used in this video?
Can you please also show from which table have you used the Year and the Month columns in the table visual.
Thank you, sir.
Nicely explained. But I want to know if I want to write a measure for the maximum sales of July 2001, how to do that? I tried but it didn't work.
as i am student i am not affordable to this prices .thanks sir
Thanks for the video
Hi Chandeep, can't thank you enough for your contribution to the BI community.
Your explanations are spot on and easy to understand, you are what all teachers should aspire to be.
Quick question, Calculation Groups, is that part of your DAX course or have you posted a video on UA-cam about that? Will register for your course as soon as I'm able to, quantity content such as yours does need to be paid for. Keep doing what you're doing brother!!!!
Thanks Francis,
I have not created an explicit video on Calculation Groups but I have used them to solve problem in various videos. I think it's time to add them to the course and make a few video exclusively on CGs.
Thanks again!
Excellent!
Thank you!
I use Summarize function to summarize transactional table before using Iterator function It works 😁
Awesome 👍👍👍
good explanation .......bro
Thanks Suresh!
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?
Big fan of your work @chandeep
Thanks Man !
That's Amazing .......
Thank you!
Great. Thx.
Nice Explanation
Thank you!
Thanks for your help
Happy to help!
Do I used mention trick for max Sales made by salesman in power query
Thank you
Can you please start power bi series ?