Row Context and Context Transition

In this video let's explore two of tricky concepts in Power BI - Row Context and Context Transition.
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog
- - - - Download File - - - -
www.goodly.co.in/wp-content/u...

[@atanasprodatanasov9233]

That's the best explanation on the whole Internet! I've watched almost every single video of SQLBI, Curbal and Excelsfun... Not to mention the endless courses on Udemy... And no one, literally no one is explaining that better!

[@DrK99999]

Absolutely, I second your comments. Chandeep's Goodly channel desrves more.

[@Bangloreblogs]

Are curbal and Excel fun even good?

[@RyanReynolds89]

@@DrK99999 I’m crafting some training myself. Curious, were there specific portions of this video that helped solidify your understanding?

[@manojrajeevramg6318]

Absolutely @Atanasprod

[@dr.vaibhavhase5979]

❤

[@sayi77]

Definitely deserve more subscribers. Your explanations are excellent.

[@simangasimelane9626]

Best explanation I have heard on the Context transition. Not only did you demystify the Context Transition but helped me understand the Value DAX Function. Thank you so much.

[@rakeshranjan7647]

Same here today i really got to know for what purpose value function is used

[@cbaide100]

Finally, an understandable explanation of what Context transition is. I had seen many videos, including videos from Dax gurus but did not get the meaning of this concept until I watched this video. Kudos to the Goodly channel!

[@Wzxxx]

Thank You. Best explanation on whole YT and the one which REALLY explains a hard topic. I knew definition of context transition but till now I have never understood what is behind and no one really explains it in a understandable way

[@arpitgupta6145]

Thanks buddy for explaining context transition so simply and easily, have gone through multiple blogs and videos but wasn't able to have grip, now feeling much more confident Once again thank you so much

[@jogdeepak]

I m doing a course in Business Analytics and just finished PowerBI. This video gave me a clear understanding of the diff between and measure and a column and also whats row context, this clarity i did not get from my trainer from the institure. Hats off to Chandeep.

[@meghasyam427]

OMG!!!! I have seen a bunch of other channel videos but I couldn't understand 1% of it. But the way you have explained graphically just made me understand it a lot easier. Absolutely amazing. I'm going to check all the videos of yours from now. Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@felix-antoineboily-audet8261]

Despite watching multiple videos on the subject, I wasn't totally grasping this concept of Context Transition. Your video helped me a lot in solidifying my understanding. Good job and thank you so much!

[@djardar]

The only video that finally made me understand context transition! Thank you very much

[@joaorataoo]

Excellent explanation. You were able to explain in a very simple way a complex and major DAX topic.

[@smartshan4u]

very effectively and simply explained -ROW and CONTEXT Transition, the very essence of understanding DAX. Great thanks!

[@tlee7028]

Thank you! For making a difficult concept so simple to understand with the examples and clear explanation !

[@judithokemwa2807]

Goodly, you have explained a really abstract concept so clearly!! I just couldn't wrap my mind around filter context, row context and context transition until your videos. They're the best on the subject.

[@GoodlyChandeep]

Glad it was helpful !

[@pravinshingadia7337]

Best description of Context Transition I have heard. Listened to loads of videos and first time I've actually understood it finally.

[@GoodlyChandeep]

Thanks.. glad you found it helpful!

[@harneetkaursandhu7050]

I am able to have some clarity on this topic for the first time through this video. Excellent work done. Please keep going 👏

[@bsai1070]

awesome explaination.that is the exact frequency im looking for .Fast and precise.Not wasting any time

[@mohsenbenromdhane7643]

I've watched all these Dax guru's to understand context transition but only this video was really helpful cheer bro keep moving forward

[@ImranHussain-xv4se]

Now I understood the concept of context transition properly, thanks goodly

[@databrainspro]

Best ever video! Thanks … I fully understood.😊

[@vijayparsai7291]

Awesome Explanation this type of explanation I was search from last 6 month but here my searching end. Thank you so much @chandeep sir.

[@samranjan6241]

Beautifully Explained Goodly...Crisp and clear

[@GoodlyChandeep]

Glad you found it helpful!

[@phorton968]

Clear and concise. To the point.

[@anupamabasu2392]

Absolutely awesome!!! Thank you!

[@rajeevagarwal6519]

Excellent explanation of this topic, this was something I was searching from very starting. It could not be better than this. !!!

[@gabrielegrano8204]

Best explanation about context transition!!

[@user-kw7ce2mh3j]

Amzing explanation. Really helped me to understand row context

[@cnieberd6072]

I definetly agree with the previous positive comments - very well explained. What helped me are the Powerpoint slides with visualizing the table workflow step by step. Congrats!

[@GoodlyChandeep]

Great to hear!

[@abhinavgupta7620]

Best Explanation i have ever come across..

[@JoyOFIndia]

This is Amazingly explained so well . Thanks a lot for the valuable teaching :)

[@wwpharmacist]

Crystal clear 🎉 Thanks

[@HaiderAli-vt8wn]

Clear and concise...thanks

[@azizahmedkhan669]

your videos are too good and easy to understand, please make a series of POWER BI videos like a step by step tutorial for any one who wish to learn POWER BI, many a times people doesnt know whether to start and they always have question whether they have learn most of the essential POWER BI topics or not, so please make video list covering all POWER BI essential topics chapter by chapter.

[@ramakrishnaravula8768]

Thank you bro way of explanation , Please make some more videos on Dax functions and functionality

[@swarnadipbandyopadhyay1727]

Sir.. This is the best explanation I have received so far on Context Transition. I have read books on DAX but this concept still eluded me. You have used those diagrams that are the best instruments to clarify what is really going on in DAX.

[@GoodlyChandeep]

Excellent Swarnadip!

[@naidupinninti7543]

Very insightful. Thanks man.

[@user-li7mq5hp9g]

Great explanation! Thank you.

[@shafa7668]

I have been watching this for a couple of years. It didn't click. But I got it now. Thanks mate!

[@GoodlyChandeep]

Great to hear Shaf!

[@tacijjola]

Great video. Thank you, especially for the VALUES function. That's all much clearer now. Thank you Goodly

[@GoodlyChandeep]

Glad you like it!

[@bravucod]

I was having such a hard time understanding this concept but you made it extremely clear!!!!

[@GoodlyChandeep]

Thanks Daniel - I am sure you'll like this context transition video too kzbin.info/www/bejne/poWsY3SJnMqWfaM

[@agustinpena948]

AGREED! Best explanation by far out there. Thanks for doing this!

[@GoodlyChandeep]

Thanks a ton. Glad you liked it!

[@christophernicholas778]

Amazing explanation! Thanks

[@charlesabboud1613]

What a fantastic explanation, thank you very much my friend

[@hashanwijerathne1158]

Best explanation ever for Context Transition

[@wayneedmondson1065]

Awesome. Thanks for the clear and concise explanation. Thumbs up!!

[@GoodlyChandeep]

Glad you enjoyed it!

[@sbn4862]

I read more books about DAX, but all with unsuccessful result, I've started see your video resently, it seems to me more usefull. How mutch i paied.....steel no result PLEASE KEEP THIS METHOD ALWAYS. AND THANK YOU VERY MUTCH!!!!!!!

[@GoodlyChandeep]

Glad it was helpful!

[@fealgu100]

Excellent work! As usual.

[@ItsWithinYou]

Super! Thanks for sharing!

[@udayakumarsakthivel6285]

Hey bro. Thanks for such simple explanation

[@houssamayoubi8715]

Great video, Thank you

[@maeshakib9646]

Honestly you deserve more subscribers and views. Respect and love from Bangladesh

[@AdnanKashemOxe]

Excellent lessons Bro... Keep it up.. Best Wishes

[@tuaantuaan2323]

thank you so much for making this video goodly man

[@shubhamkhatri6908]

Simply the best. Love from India❤️. Just have one question, why context transition didn't happen in sumx scenario. True champ- Chandeep

[@ms-rc9tx]

Very well explained.

[@pallavijain3957]

Wow... excellent explanation...that clears my confusions...thank you.. Just one question...if a create a variable for sumx sales before values function..will it work here??

[@seamushand8439]

Great explanation

[@shoaibrehman9988]

Excellent finally first time understand this concept in deep dive. Thanks

[@GoodlyChandeep]

Glad you found this helpful

[@abeerattia4523]

Thanks for this explanation , the first time i understand this topic that easy and that clear , well done

[@GoodlyChandeep]

Glad it was helpful!

[@husnabanu4370]

Clear explanation i had spend 2 days seeing all different videos to understand row and filter context ...Im atleast clear now with respect to row context

[@husnabanu4370]

Can we use ALL instead of VALUES since our aim is to give the unique products??

[@GoodlyChandeep]

@@husnabanu4370 No because VALUES will return the unique product for the current context ALL will return the unique product overriding the current context. So they are different

[@marilenadonofrio9787]

Bravo! Kudos to you, Chandeep👏👏👏👏👏

[@GoodlyChandeep]

Glad you liked it

[@swapnahkn519]

very nice explanation.Just subscribed.

[@hashanwijerathne1158]

The best explanation for Context Transition...

[@GoodlyChandeep]

Thank you!

[@sanketchaudhari3458]

Hi Sir, Thank you for this video. this video has cleared all my doubts and I checked all videos but this detailed explanation havn't got on youtube ..... Thank you Sir. I am very late to subscribe your channel.

[@kennethstephani692]

Great video!

[@anuragbawankar685]

Thanks a lot sir ! I always get to learn from your each and every video .

[@GoodlyChandeep]

Glad it helped

[@punchbuddies220]

You're the best, man! Cheers

[@GoodlyChandeep]

Thanks Man!

[@LokeshKumar-yi3ln]

Great Video..

[@Amitsxna-1234]

This is great!! best explanation!!

[@GoodlyChandeep]

Glad it was helpful!

[@narendrababu2287]

Omg. How i didn't get this channel suggesion on PBI. awesome explanation.

[@GoodlyChandeep]

Welcome aboard!

[@birendrasingh849]

🙏 Superb...

[@PeterKontogeorgis]

Bit late to the party, but this is a great explanation of what is usually a difficult topic for people to understand. I only recently discovered your channel and really enjoy your method of explaining things. Look forward to future content.

[@GoodlyChandeep]

Thanks Peter! Glad you enjoyed it 😊

[@nitinat3590]

Amazing explanation. Take a bow!

[@GoodlyChandeep]

Glad you liked it!

[@hydham9924]

Amazing content. Thanks a ton.

[@GoodlyChandeep]

Glad you liked it!

[@pmsocho]

Great! Thanks!

[@GoodlyChandeep]

You're welcome!

[@Richkotite1]

I have to agree, SQLBI, Curbal and Udemy are not at your level. Your explanations are the best. Thank you!

[@3danim8r1]

Great!

[@sandeepreddy7687]

Great video and clearly explained.

[@GoodlyChandeep]

Glad you liked it

[@EricHartwigConsulting]

I love this video! It really breaks things down in a way that I can follow. I do have a question about your courses, which one would you recommend for someone to learn DAX that is geared toward Excel and not Power BI?

[@GoodlyChandeep]

Would recommend my combo course on DaX + M Language

[@EricHartwigConsulting]

@@GoodlyChandeep found them! Thank you!

[@snandhini9780]

can you please give the tips for creating better visuals. your all videos are very helpful for me and very clear to understand.

[@kyiwinhtun]

Thanks!

[@joncannaday250]

Thank you for posting, I have your videos for career growth and Bishop Barrons' for Spiritual growth. I describe the quality of both of your presentations as "clean waters" and if I had children I would let them swim in these pools of thought. Again thank you for your knowledge and quite frankly I feel debited to both of you.

[@GoodlyChandeep]

Made my day Jon. Cheers

[@krishnaiyer5698]

Excellent

[@blink2008]

just want to say great video! subscribed

[@GoodlyChandeep]

Thanks for the sub!

[@georgiostsichritzis2152]

Thank you. So actually the trick is using MAXX over the unique products to change granularity?

[@PaulaWeb3andCrypto]

Great Video, important concepts for DAX users to understand. I am including this video in today's Excel curation corner, and I have sent you on some $bat and $hive tips. thanks for creating awesome content.

[@GoodlyChandeep]

Hey Paula, thanks for generously sharing my video. Appreciate this a lot :)

[@GoodlyChandeep]

Also not sure where should I look for $bat and $hive. Let me know

[@PaulaWeb3andCrypto]

​@@GoodlyChandeep you can find out about the bat tips in this video kzbin.info/www/bejne/poPMamivfqt6p80 and the hive tips, you had a problem setting up a hive account before right?

[@sonamsuri3475]

Insightful video indeed. Sir, referring to explanation given in this video, how do we create a measure to calculate total sales provided quantity and price columns are part of different tables. Sumx function perform calculations on the same columns of same table only.

[@GoodlyChandeep]

Hello Sonam. 1. You need to create a relationship (one to many) between 2 tables 2. Then write the following =SUMX ( SalesTable, SalesTable[Units Column] * RELATED ( ProductsTable[Price Column] ) ) The Related function is like writing VLOOKUP Refer to this video - kzbin.info/www/bejne/bHPHn4SJYs2NrNk Hope this helps

[@kunalgupta5667]

Keep doing this great work sir☺️

[@GoodlyChandeep]

Thank you!

[@grahamlindsay9798]

Great explanation 👍

[@GoodlyChandeep]

Glad you liked it

[@CoopmanGreg]

Hard topic, well explained.

[@kailashmehta7568]

Great explanation !!!

[@GoodlyChandeep]

Glad you liked it!

[@GodParticleZero]

I thought the context transition occurred because the measure [Total Sales] has an implicit calculate wrapped around it when used in an expression. Thus, it iterates through the column returned from values, converting each row to a filter, which is then applied to the [Total Sales] sales table. Kind of hard to explain, but I hope that makes sense

[@SuperDarekR]

You'r the BEST

[@GoodlyChandeep]

Glad you found it helpful!

[@monirmostafiz2919]

awesome

[@aryansena7290]

Awesome video this is..

[@GoodlyChandeep]

Thank you

[@natam1595]

Godly! 💗

[@jeanescalona2587]

The Best explanation ever!!! Where Can I find your DAx mastering training?

[@GoodlyChandeep]

goodly.podia.com/power-bi-dax-course

[@waynethurman2144]

This guy takes the "difficult" and makes it simple. I think that is who Einstein said were the good teachers. The bad teachers can't or refuse to do such!

[@GoodlyChandeep]

Thanks Wayne, I am glad I could help!

[@Mehboob11]

Thanks for the awesome video. A small doubt. I understand that context transition is not happening when we write the formula instead of the measure while calculating the best selling product . But why isn’t the context transition happening? Does context transition depend on the functions?

[@rick_.]

Measures always have an implicit, and hidden, CALCULATE.

[@surajchavan6447]

Awesome 😎😎

[@GoodlyChandeep]

Thank you! Cheers!