You are the sole reason why I finally understand context transition! I have probably watched over 20 hours of KZitem 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! 😊
@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
7 ай бұрын
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!
@sandip_bettereveryday
Жыл бұрын
Awesome. The clarity that you offer is unmatched.
@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...)?
@RidharvJoshi
Жыл бұрын
It's just awesome that measure I have been looking for few days Thank you so much sir❤️
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@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!
@ericlandry3971
Жыл бұрын
Wow! This guy is an Animal! So knowledgeable yet makes it somewhat east to understand!!! Keep it up!
@buddymartin71
Жыл бұрын
I love the validation techniques too! Great helpful video!
@aijaz4441
11 ай бұрын
Great content explaining the mind boggling concepts of DAX.
@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?
@hoaithuongluu2869
Жыл бұрын
Again, but I have to say that "you're awesome at explaining DAX"
@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!
@pmsocho
Жыл бұрын
Great examples! Thanks!
@GoodlyChandeep
Жыл бұрын
Glad you like them!
@mohammed333suliman
Жыл бұрын
The best video I have ever seen in this channel, thank you very much
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@user-kc1gv7hl4u
Жыл бұрын
Very well explained. Thank you!
@muratsahinel7302
Жыл бұрын
Good job!! 'it 's very simple and impressive.. Thanks to all Goodly Team :) Very well appreciated 👏
@lmk001
6 ай бұрын
Worked great! Thanks!
@joaopinaledo9675
Жыл бұрын
Very Good Explaining. Tanks
@b0rme
Жыл бұрын
Please keep making these videos. Thank you so much
@GoodlyChandeep
Жыл бұрын
Glad you like them!
@navisalomi
Жыл бұрын
Damn awesome 👌. I'm blown away.
@GoodlyChandeep
Жыл бұрын
Thanks!
@bradj229
Жыл бұрын
Very cool examples. Thanks for the clear explanations.
@GoodlyChandeep
Жыл бұрын
Glad you like them!
@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.
@KirillBezzubkine
Жыл бұрын
Thank you mister. U do tons of good for PBI devs
@GoodlyChandeep
Жыл бұрын
My pleasure!
@kunalr_ai
Жыл бұрын
Bhai tera content shaandaar laga par thoda aur umda hona chahiye..
@hariprasad289
Жыл бұрын
Superb Sir, thank you
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@sujit3375
Жыл бұрын
Hoping that you can bring teach us all other course to and end up getting in career as data scientist
@seamushand8439
Жыл бұрын
Brilliant explanation. Thanks
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@need2knowtamil249
Жыл бұрын
Awesome 👍👍👍
@MrKamranhaider0
Жыл бұрын
Precisely explained
@GoodlyChandeep
Жыл бұрын
Thanks!
@atanasprodatanasov9233
Жыл бұрын
Really good video!
@GoodlyChandeep
Жыл бұрын
Thank You !
@arunkumarkesavan6077
Жыл бұрын
Come on Man... you are just awesome....
@GoodlyChandeep
Жыл бұрын
Thank you!
@vishnupp5944
4 ай бұрын
Great
@unnikrishnansanthosh
Жыл бұрын
excellent. thanks for sharing
@GoodlyChandeep
Жыл бұрын
Glad you liked it!
@willianthalles
Жыл бұрын
ConcatenateX I don’t know that until now. Tks
@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?
@user-ie5cz1co6u
Ай бұрын
Best Selling Product name....for this Inside Concatenate Function you can use MAXX , AM i right???? Please respond
@mageshwarans5367
Жыл бұрын
Continue doing this, good job
@GoodlyChandeep
Жыл бұрын
Thanks!
@surajchavan6447
Жыл бұрын
As always Awesome ! 😎
@GoodlyChandeep
Жыл бұрын
Thanks!
@EricaDyson
Жыл бұрын
Ace!!!!
@TusharPant-mu1js
10 ай бұрын
where is the data source for the following?
@prasad9976
Жыл бұрын
hi sir where to get data for practice purpose ?
@GoodlyChandeep
Жыл бұрын
Check the link in the description!
@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
@ahmadhassanbakr
15 күн бұрын
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]
Пікірлер: 76