Using RELATED and RELATEDTABLE in DAX

Why and when to use RELATED and its companion function RELATEDTABLE: two common DAX functions that are required when using a row context with relationships.
Article and download: sql.bi/751669?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@rajunagavelli007]

I am learning BI, but I've got enough confident only after watching your tutorials, A Big thank You Alberto :)

[@sanjeevgupta7177]

Alberto, I find your content very accurate and meaningful. Respect from the bottom of my heart. You are a Maestro. I have learnt a lot from your videos. I cannot afford your courses but access to the free videos on KZbin are helping me a lot. Thanks for such a series of wonderful videos.

[@yusufbas035]

this man is amazing. he never gets tired of this.

[@antygona-iq8ew]

Excellent explanation, clear and easy to understand.

[@peanut-d-cat]

I may not be able to thank you everyday but i am trully grateful everytime i watch your videos.these learning gems are easy to watch i mean i dont get intimidated why I don't understand because i knew you will double down on the concept. Bless you sir.

[@info2satish]

Always waiting for your next video...a new DAX learner, your videos give so in depth knowledge... Thanks 🙏👍

[@matthiask4602]

Thank you, Alberto. I had a RELATED problem just last week. This is so helpful.

[@VictorHugo-bd3bf]

Excellent explication, Alberto. Thanks so much.

[@willianthalles]

Well explained professor! Thanks and keep bringing it up

[@mohamedfouad7958]

Thanks Alberto for your easy explanation

[@ChristianKey]

Thanks for the video. This is very useful to know.

[@Bharath_PBI]

Thank you, I always thought in (weak) limited relationships both RELATED() and RELATEDTABLE() does not work. This video helps but also makes me think which other DAX functions works (and do not work) in limited relationships.

[@AhmedKhaliet]

From all of my heart, thank you ❤️

[@MarcosRezinovsky]

Excelent. Practical. Real use cases. Expaining what works and what do not work? I´d like to get the same in spanish 😀

[@insidehead]

from which resource do u study? u r amazing. your teaching skills r amazing..

[@erinfield1943]

2:02 - RELATED -- creates a calculated column in Sales (Many) and accesses a column in Product (One) 7:41- RELATEDTABLE

[@joaoluismartins]

Great video, finally understanding the use of RELATEDTABLE() function. However, I've got a question on this one. What is difference between using CONTROWS ( RELATEDTABLE (SALES) ) and applying Context Transition CALCULATE ( COUNTROWS (SALES) ). I suppose both would generate the same result/values. Is there any performance impact?

[@SQLBI]

They are identical, same result, same performance.

[@yusufbas035]

I love the data formatting in Power BI. It's the easiest and the most dangerous thing. if you know what are you doing it took only 1 min but only one mistake can collapse all your data.

[@datawhipper]

Thanks for this great video Alberto. Can you talk more on the Island you talked about when explaining limited and strong relationship. Thanks

[@SQLBI]

See this: www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/

[@pratikfutane8131]

Masterstroke 💯👌👌🦸‍♂️

[@Bharath_PBI]

A question out of this topic, is there any way to retrieve the historical refreshes that occurred on the SSAS Tabular model (something like refresh history in PBI Premium datasets)? Thanks in advance for your guidance.

[@yuriperesf]

Great video as always! I have a question: Considering the following DAX queries A: EVALUATE ADDCOLUMNS ( SUMMARIZE ( 'Product', 'Product'[ProductSubcategoryKey] ), "Subcategory", RELATED ( ProductSubcategory[ProductSubcategory] ) ) B: EVALUATE ADDCOLUMNS ( 'Product', "Subcategory", RELATED ( ProductSubcategory[ProductSubcategory] ) ) Why does query A doesn't work while query B works? What does the SUMMARIZE (or SELECTCOLUMNS for that matter) do that it causes the RELATED function to stop working?

[@SQLBI]

Query A performs a GROUPBY and the result is not a row in Product, but a value in Product[ProductSubcategoryKey]. Because RELATED is a function that "unlocks" the access to the expanded table (which is an internal implementation detail), when the row context is not on Product, you do not have access to the expanded table. The result of SUMMARIZE / SUMMARIZECOLUMNS is never a table that has relationships in the model, it's always a table that still keeps the data lineage of the columns, but cannot leverage model relationships.

[@uyu96]

But for limited relationships we need a refresh of the dataset to get the data from Direct query

[@sandeepbarge4699]

Are there any scenarios when we need not use RELATED and RELATEDTABLE functions to access column from another table?

[@Milhouse77BS]

LOOKUPVALUE also doesn't work with a limited relationship, in my experience.

[@SQLBI]

Yes, RELATED only works with regular relationships.

[@ed2921]

The catch cry “enjoy DAX” is only possible because of SQLBI DAX = RELATED (SQLBI)

[@sahilsukhadeve]

Man🔥🔥👍

[@tolgakaptan6633]

Hello. How do you increase the font size of the formula bar easily?

[@SQLBI]

Ctrl+MouseWheel

[@niranjanrana1714]

ctrl++

[@anikeetdey3411]

Can you provide the data sets user please. so that we can practice it properly..plzz 🙏

[@SQLBI]

Follow the link in the description!

[@rjbush7955]

Maybe RELATED should be renamed RELATEDVALUE so it is clearer.?

[@e.l.2405]

wrong E-R schema, because ProductDQ should be connected to Product table, not to Sales table.

[@EnneagramTarot-zu8kp]

*NEW COLUMNS* 3:00- RELATED 4:30- IF(RELATED) 6:00- demonstration on how RELATED doesn't work with a limited relationship 8:30- COUNTROWS(RELATEDTABLE) 10:39- AVERAGEX(RELATEDTABLE) 12:40- AVERAGEX(ALLNOBLANKROW)...COUNTROWS(RELATEDTABLE) *NEW MEASURES* 14:50- SUMX(COUNTROWS(RELATEDTABLE))