You are the sole reason why I finally understand context transition! I have probably watched over 20 hours of TH-cam 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!
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 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...)?
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?
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!
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.
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.
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?
I have question. What is mean by best selling product. The maxx() function will give us the last date of the year in month on the day level. This is not best selling but the date and context transition is applied from the visual and just give you this values from sales and calendar table. because of filtration. Clear my doubt. Thanks
MAXX ( Calendar, [Total Sales] ) works like this In the current filter context. 1. Go in each row of the Calendar Table and calculate Sales for each row (i.e. each date). 2. Then return the max sales value. Hope this clarifies.
@@GoodlyChandeep actually when i watch you video than my mother say me to go market and bring some Commodities . U cant imagine i think about your maxx all the way to market 😀😀. Then when i come back i apply it on myself and its work. Yes your reply is correct 💯. Thanks for your kind reply
Hello Chandeep @GoodlyChandeep. Thank you for your marvelous videos. I wonder if you have an explanation for the below problem: The below measure is giving me the error: "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
chk RunWD = VAR fdt = [chk FDate] VAR Result = CALCULATE( COUNTROWS(DimWDates), DimWDates[Date] > [chk FDate], --> returned error! DimWDates[Date] fdt, --> worked fine!!! DimWDates[Date]
You are the sole reason why I finally understand context transition! I have probably watched over 20 hours of TH-cam 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!
The explanation of the elusive Context Transition concept presented in this video is the best on the whole Internet.
Thank you! 😊
You are genuinely the best Powerbi teacher I have learnt from. I have no other words to say!!!!
Oh this is gold. Great examples using context transition and nifty display of problem solving. Great job!
Thanks Takpor!
Man you are awesome. The way you go through your tutorials is amazing and really easy to follow
Glad you like them!
Awesome. The clarity that you offer is unmatched.
Thanks!
Best video on Context transition concept. Watched all three videos on Context transition concept, and they were really good. Thank You.
Happy to hear that!
Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!
Great content explaining the mind boggling concepts of DAX.
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.
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.
@@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...)?
It's just awesome that measure I have been looking for few days Thank you so much sir❤️
Glad you like it!
I love the validation techniques too! Great helpful video!
Again, but I have to say that "you're awesome at explaining DAX"
I was looking for that solution of bringing text in measure. Thank You So much
Glad it was helpful!
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?
Very well explained. Thank you!
Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏
The best video I have ever seen in this channel, thank you very much
Glad you like it!
Very Good Explaining. Tanks
Great examples! Thanks!
Glad you like them!
Please keep making these videos. Thank you so much
Glad you like them!
Worked great! Thanks!
Thank you mister. U do tons of good for PBI devs
My pleasure!
Superb Sir, thank you
Glad you like it!
Awesome 👍👍👍
Very cool examples. Thanks for the clear explanations.
Glad you like them!
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!
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.
@@GoodlyChandeep Thanks a lot for the rapid response! I wasn’t considering other iterators other than the X functions.
You’re awesome!
Hoping that you can bring teach us all other course to and end up getting in career as data scientist
Brilliant explanation. Thanks
Glad you like it!
Really good video!
Thank You !
Come on Man... you are just awesome....
Thank you!
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.
Damn awesome 👌. I'm blown away.
Thanks!
Precisely explained
Thanks!
Great
Continue doing this, good job
Thanks!
excellent. thanks for sharing
Glad you liked it!
As always Awesome ! 😎
Thanks!
ConcatenateX
I don’t know that until now. Tks
Ace!!!!
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?
Bhai tera content shaandaar laga par thoda aur umda hona chahiye..
Best Selling Product name....for this Inside Concatenate Function you can use MAXX , AM i right???? Please respond
I have question. What is mean by best selling product. The maxx() function will give us the last date of the year in month on the day level. This is not best selling but the date and context transition is applied from the visual and just give you this values from sales and calendar table. because of filtration. Clear my doubt. Thanks
MAXX ( Calendar, [Total Sales] ) works like this
In the current filter context.
1. Go in each row of the Calendar Table and calculate Sales for each row (i.e. each date).
2. Then return the max sales value.
Hope this clarifies.
@@GoodlyChandeep actually when i watch you video than my mother say me to go market and bring some Commodities . U cant imagine i think about your maxx all the way to market 😀😀. Then when i come back i apply it on myself and its work. Yes your reply is correct 💯. Thanks for your kind reply
hope you got the commodities right! 😁
where is the data source for the following?
hi sir where to get data for practice purpose ?
Check the link in the description!
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.😎
Thanks for posting! Reposted on LinkedIn ⭐⭐⭐⭐⭐⭐⭐⭐
Glad! Thanks
Hello Chandeep @GoodlyChandeep. Thank you for your marvelous videos. I wonder if you have an explanation for the below problem:
The below measure is giving me the error:
"A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
chk RunWD =
VAR fdt = [chk FDate]
VAR Result =
CALCULATE(
COUNTROWS(DimWDates),
DimWDates[Date] > [chk FDate], --> returned error!
DimWDates[Date] fdt, --> worked fine!!!
DimWDates[Date]