Understanding Row Context in DAX using Power BI

[@Marta-ns8yy]

Absolutely GAME CHANGER for me !!! I've been struggling for a week with calculated table now I cant wait to go back to my project !!Thank you

[@PragmaticWorks]

Great to hear! Thanks for watching!

[@patrickf01]

You giving me a new job! Thanks again. Old school Excel and VB user. This is sooo much more intuitive. Things have come a long way.

[@PragmaticWorks]

Awesome! Glad it helped Patrick - Mitchell Pearson

[@theaverageglasses6197]

Fantastic video, this helped me wrap my head around the issue with row context not filtering. Your examples are super clear and I really appreciate the way you keep this accessible even to people from a non-programming background.

[@PragmaticWorks]

Great to hear!

[@timcrowley7197]

Mitchell - That was OUTSTANDING! Great pace and example. Thanks for staying in the "shallow end"!

[@PragmaticWorks]

Thanks Tim, glad you enjoyed it!

[@chitungchang]

Thank you Mitchell. This video really explains all the mysterious in my mind about DAX and filter applying

[@philippeblanc2341]

I love your teaching style ... Very clear and easy to understand... Thanks a lot

[@PragmaticWorks]

Glad to hear that

[@sambasivarao576]

I found this very helpful. The step-by-step explanation is very good and can be understood very easily. Love to see more videos from you.

[@PragmaticWorks]

Thank you! Will do!

[@luckxn]

Great job Mitchell!! really love your videos and really look forward to seeing more examples of data modeling and advanced DAX usages.

[@mint9121]

Wow, this is fantastic for people trying to learn this. Thank you!

[@andreashermle2716]

Congratulations on this video. Very clear and informative. Thank you.

[@PragmaticWorks]

Glad it was helpful! Thanks for learning with us!

[@ashwin147]

Thanks for teaching us row context in a simplified way. Looking forward for future videos

[@PragmaticWorks]

Glad you liked it!

[@SotirisKD]

Excellent presentation Mitchell. You are the best!!! You make complex things seem easy. Thank you so much.

[@PragmaticWorks]

Glad you enjoyed!

[@ramakumarguntamadugu1299]

Great Explanation.. very helpful. thanks for sharing it.👍👍👍👍

[@PragmaticWorks]

Glad you enjoyed it!

[@rerangelt]

Hi! Great video. Very helpfull. The filter contex is always tricky to understand. Very well explained. Wish to see more videos

[@PragmaticWorks]

Glad it was helpful!

[@totvabe1]

Superinteresting video! Looking forward for the next one!

[@PragmaticWorks]

Thanks! Glad you enjoyed, definitely more to come!

[@VIJAY-pd4jt]

Great explanation Sir...

[@PragmaticWorks]

Thank you!

[@AlexKashie]

Wow, thanks a ton!

[@jameshenryhinton]

Excellent teacher!

[@PragmaticWorks]

Wow, thank you!

[@patrickf01]

Love your training style. Brilliant!

[@PragmaticWorks]

Thank you Patrick, much appreciated! - Mitchell Pearson

[@kebincui]

Mitchell, you are an excellent tutor 👍👍👍👍

[@JohnSullivan1]

This was good. Thanks Mitchell.

[@PragmaticWorks]

Thanks John!

[@sonetmollick4630]

Mitchell! what a great explanation. Thanks a lot

[@PragmaticWorks]

Glad you enjoyed it!

[@AlinaAlina-bi9vf]

Best teacher!

[@PragmaticWorks]

Wow, thanks! Glad you enjoyed it!

[@johnnynguyen7657]

absolutely amazing explanation 👏 glad to have found your channel. keep it up!

[@sebainuk]

very clear! much appreciated!

[@ibrahimgbadebo4628]

Amazing Job

[@PragmaticWorks]

Thanks!

[@gabororoszi75]

Fantastic explanation Mitchell ! Is there a video on context transition from you?

[@venkatareddykummitha5863]

It's an awesome/fabulous video. Do a video on Power BI Service.

[@matthewb2133]

If row Context is used active relationships are disabled. How the hell am I just learning this now? Surely this should be Day 1 of every Power BI course! Thx for the vid BTW

[@vincenzo4259]

Thanks

[@PragmaticWorks]

No problem

[@shwetkumar1719]

Hi Please provide data set for Practice. why the active relationship get deactivated when we have created the active relation?👀👀

[@mahpv3953]

Very useful tips

[@PragmaticWorks]

Thanks a lot! -Mitchell Pearson

[@fadwa2413]

Thanks a lot !!!

[@PragmaticWorks]

You are welcome!

[@TheSsqr]

Hi Mitchell, very helpful. Really grateful for your videos. I have question, why you did not use related table in large values table and used related function. Thanks.

[@amaludayanga9383]

calculate(MAXX(Sales,Sales[Order Date]),Customer[CustomerKey]) This fuction is work and can be done last order date each customer

[@italocesar1444]

Nice! When is the next one coming? 🤔

[@alexmeraru4364]

Hi! Fresh new in Power BI, coming from Apsheet. I have a table where one record's status depends of another record's status. Wrong data model but nothing I ca do about it (client's) Sales and deliveries in the same table One delivery per sale One product per sale Once delivery is complete, Sale will be complete. Dims: Transaction date Delivery place Product For each Sale I am looking to find another record (delivery) with the same TDate, DPlace and Product and return it's status. What formula works similar to Select(Table[Column], AND(conditions))? Thank you!

[@RavinderKumar-gl8cy]

Sir, I am having the data of sales amount having the column State and District. I have created a measure for total sales. and created 2 Slicer i.e. State and District and I have sync slicer for all the pages of the report. I have created a table with column State and Sale. If I don't selected any slicer from state then default value should be State Column and Sale Column and If I select any state the respective district of the state should come i.e. District column in place of State Column and Sale column. Please advise sir, how it can be done.

[@Ukineko]

What should I do if I need not the date of the last order, but its ID? I still need to determine, which order was the last, but what I want in the calculated column is not its date, but its ID. I'm stuck.

[@LetsWanderworld]

where can i get its source file and source code of DAX

[@abrilgonzalez7892]

Can anyone help me please? Where are the files to download ? I mean the dataset Thank you

[@statesman6379]

Regarding starting at @11:36. ChatGPT is my personal IT tutor. According to Chat, the RELATED function should only be used on the one side of a relationship and never on the many side. Quote: "The information provided by the KZbin instructor is not accurate. The DAX RELATED function is specifically designed to be used on the "one" side of a one-to-many relationship. It allows you to retrieve values from the "many" side based on a matching key. If you are on the "many" side of a relationship and the relationship is broken due to a calculated column, using the RELATED function will not fix the issue. In fact, using RELATED in such a scenario may lead to incorrect or unexpected results. To address issues with broken relationships caused by calculated columns on the "many" side, you would typically need to review and modify the calculated column or consider alternative approaches such as using measures or calculated tables. Remember, the RELATED function is used to navigate from the "one" side to the "many" side of a relationship. If the relationship is broken, the RELATED function will not resolve the issue." The following is the question that I asked ChatGPT: A KZbin instructor just said that if I am on the many side of a relationship, and the relationship is broken due to the side affect of a Calculated Column, then I can use the RELATED DAX function to fix it. Is this correct? I was told that RELATED should only be used on the "one" side of a one-to-many relationship. The example the KZbinr used is: Product Name = RELATED(‘Product’[English Product Name])

[@PragmaticWorks]

Hello and thanks for commenting on our video. I have reviewed the video and it is 100% correct and accurate. If you are in the table, on the one side of the relationship, for example a dimension table, related WILL NOT work to return information from the many side of the relationship. Related function only returns a single value and therefore will only work if you are on the many side of the relationship trying to return a single value from the one side. The code examples in the video back up the context provided. Similarly, relatedtable returns a table and therefore, if i'm in a dimension table and want to return a set of related rows from the many side of a relationship, I would use related table, since it can and will return a table expression. - Mitchell Pearson

[@statesman6379]

@@PragmaticWorks Awesome! Thanks for the clarification. So it seems it doesn't matter which side of the relationship you are on if you are using relatedtable since it returns a table, is this correct?

[@PragmaticWorks]

​@@statesman6379 Technically Yes, you can use RELATEDTABLE on either side... but relatedtable is more complex to work with because now you have a table expression and you need to perform an operation on that table to return a scalar value. In contrast, the related function will return a scalar value by default and will not require further manipulation and therefore if you are returning a single value from the one side of the relationship RELATED would be ideal. In the video, I probably use a sumx or equivalent type function on top of relatedtable to return a scalar value.

[@skerody]

Double like

[@kowsergazi]

For 1 to Many ---- USERELATIONSHIP For Many to 1 ---- RELATED Is it the golden rules?

[@Wzxxx]

"Row context exist therefore relation is disabled" = no idea why and what does it mean? I see no logic behind this. (this is beginner question:) I don't think the row context is explained here.