Simple and Powerful Context Transition Examples in Power BI

In this video we will be discussing 3 simple but powerful Context Transition Examples in Power BI. we will be covering:
Example 1 - Calculate Sales for Best Selling Day of the Month
Example 2 - Calculate Best Selling Product's Sales Value
Example 3 - Calculate Best Selling Region's Sales Value
===== ONLINE 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...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File - goodly.co.in/simple-and-power...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== CHAPTERS =====
0:00 Intro
00:34 Example 1 - Calculate Sales for Best Selling Day of the Month
4:19 Re-checking the Answer Manually
7:15 Example 2 - Calculate Best Selling Product's Sales Value (Part 1)
9:11 Example 3 - Calculate Best Selling Region's Sales Value
11:06 Example 2 - Best Selling Product Names (Part 2)
15:48 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ​
Official After The Fall KZbin Channel Below
kzbin.info/door/GQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

[@christophernicholas778]

You are the sole reason why I finally understand context transition! I have probably watched over 20 hours of KZbin videos and nothing made sense. This video and the other one you made a couple years ago made the concept so incredibly clear. It’s actually quite simple once you understand it. I cannot thank you enough!

[@cbaide100]

The explanation of the elusive Context Transition concept presented in this video is the best on the whole Internet.

[@GoodlyChandeep]

Thank you! 😊

[@buddymartin71]

I love the validation techniques too! Great helpful video!

[@terrylee2094]

Man you are awesome. The way you go through your tutorials is amazing and really easy to follow

[@GoodlyChandeep]

Glad you like them!

[@meghasyam427]

You are genuinely the best Powerbi teacher I have learnt from. I have no other words to say!!!!

[@tak0331]

Oh this is gold. Great examples using context transition and nifty display of problem solving. Great job!

[@GoodlyChandeep]

Thanks Takpor!

[@aijaz4441]

Great content explaining the mind boggling concepts of DAX.

[@lmk001]

Worked great! Thanks!

[@muratsahinel7302]

Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏

[@user-kc1gv7hl4u]

Very well explained. Thank you!

[@bhaskarsubbaiah6002]

Hi goodly, No body Can Explain Lik you "wonderful and clear Explanation". Just One Query When created "Virtual Table" there is No relatioship for context transition between table?

[@ericlandry3971]

Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!

[@sandip_bettereveryday]

Awesome. The clarity that you offer is unmatched.

[@GoodlyChandeep]

Thanks!

[@joaopinaledo9675]

Very Good Explaining. Tanks

[@williamarthur4801]

Wonderful stuff, I thought of using SELECTCOLUMNS(TOPN(1,dItems,[Tsales]),"Top",[Item] ), but don't think this would work with ties. I'm going to have to look into UNICHAR as it's not something I've ever used / understood what it's supposed to do.

[@vishaljhaveri7565]

Best video on Context transition concept. Watched all three videos on Context transition concept, and they were really good. Thank You.

[@GoodlyChandeep]

Happy to hear that!

[@nishantkumar9570]

I was looking for that solution of bringing text in measure. Thank You So much

[@GoodlyChandeep]

Glad it was helpful!

[@bradj229]

Very cool examples. Thanks for the clear explanations.

[@GoodlyChandeep]

Glad you like them!

[@pmsocho]

Great examples! Thanks!

[@GoodlyChandeep]

Glad you like them!

[@RidharvJoshi]

It's just awesome that measure I have been looking for few days Thank you so much sir❤️

[@GoodlyChandeep]

Glad you like it!

[@mohammed333suliman]

The best video I have ever seen in this channel, thank you very much

[@GoodlyChandeep]

Glad you like it!

[@need2knowtamil249]

Awesome 👍👍👍

[@b0rme]

Please keep making these videos. Thank you so much

[@GoodlyChandeep]

Glad you like them!

[@seamushand8439]

Brilliant explanation. Thanks

[@GoodlyChandeep]

Glad you like it!

[@KirillBezzubkine]

Thank you mister. U do tons of good for PBI devs

[@GoodlyChandeep]

My pleasure!

[@navisalomi]

Damn awesome 👌. I'm blown away.

[@GoodlyChandeep]

Thanks!

[@senthamilvm1982]

Awesome Video as always! You're a true inspiration! One Question 🙋, on this example, we are showing Total which is showing a product for the total. On what basis the measure is returning the top product in total row? Eg. Total Sales for Advanced Keratin Shampoo.

[@GoodlyChandeep]

The year total for example is the best selling product of that year. The grand total product is the overall best selling product of all time.

[@denissipchenko2455]

@@GoodlyChandeep As far as I understand, question is related to 13:18 of the video. TOPN returns the right answer if Product table is sorted by Total Sales Desc. How do we know that it's sorted this way (not randomly, or by product name...)?

[@sujit3375]

Hoping that you can bring teach us all other course to and end up getting in career as data scientist

[@hoaithuongluu2869]

Again, but I have to say that "you're awesome at explaining DAX"

[@hariprasad289]

Superb Sir, thank you

[@GoodlyChandeep]

Glad you like it!

[@owenagitza9506]

Hey Chandeep! Thanks for the awesome explanation. Can you explain where does the context transition take place in the Best Selling Product Names (last example)? As I know, for it to happen we have to have either CALCULATE or measure reference inside a row context, both of which were absent. Your explanation would be greatly appreciated!

[@GoodlyChandeep]

Context Transition takes place in the TOPN function. TOPN is an iterator and it creates a row context. [Total Sales] as a measure is used in the row context of TOPN.

[@owenagitza9506]

@@GoodlyChandeep Thanks a lot for the rapid response! I wasn’t considering other iterators other than the X functions. You’re awesome!

[@unnikrishnansanthosh]

excellent. thanks for sharing

[@GoodlyChandeep]

Glad you liked it!

[@MrKamranhaider0]

Precisely explained

[@GoodlyChandeep]

Thanks!

[@surajchavan6447]

As always Awesome ! 😎

[@GoodlyChandeep]

Thanks!

[@atanasprodatanasov9233]

Really good video!

[@GoodlyChandeep]

Thank You !

[@vishnupp5944]

Great

[@arunkumarkesavan6077]

Come on Man... you are just awesome....

[@GoodlyChandeep]

Thank you!

[@AbbyRani]

Hi I have two visual tables in same page ,if the i select one row in table 1 it filters the value in table 2 but i need to know whether i can click on each row value in table 1 so that table 2 displays according to that is that possible?

[@mageshwarans5367]

Continue doing this, good job

[@GoodlyChandeep]

Thanks!

[@willianthalles]

ConcatenateX I don’t know that until now. Tks

[@EricaDyson]

Ace!!!!

[@kunalr_ai]

Bhai tera content shaandaar laga par thoda aur umda hona chahiye..

[@prasad9976]

hi sir where to get data for practice purpose ?

[@GoodlyChandeep]

Check the link in the description!

[@TusharPant-mu1js]

where is the data source for the following?

[@afignu77]

Nice video, but you talk a little bit fast and it's a little bit difficult following you for understanding what you're talking about.😎

[@tomr9969]

Thanks for posting! Reposted on LinkedIn ⭐⭐⭐⭐⭐⭐⭐⭐

[@GoodlyChandeep]

Glad! Thanks