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.

[sanjeevgupta]

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 YouTube are helping me a lot. Thanks for such a series of wonderful videos.

[krisihari]

Your explanations are always on another level!

[rajunagavelli]

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

[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.

[yusufbas]

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

[infosatish]

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

[matthiask]

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

[antygona-iqew]

Excellent explanation, clear and easy to understand.

[VictorHugo-bdbf]

Excellent explication, Alberto. Thanks so much.

[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.

[mohamedfouad]

Thanks Alberto for your easy explanation

[erinfield]

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?

[insidehead]

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

[datawhipper]

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

[willianthalles]

Well explained professor! Thanks and keep bringing it up

[ChristianKey]

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

[yuriperesf]

Great video as always!
I have a question:
Considering the following DAX queries
A: EVALUATE ADDCOLUMNS ( SUMMARIZE ( 'Product', ), "Subcategory", RELATED ( ) )
B: EVALUATE ADDCOLUMNS ( 'Product', "Subcategory", RELATED ( ) )

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?

[fungsweewong]

Can Related function get the "Text value" from the related dimension table? If yes, please show an example. TIA

[MarcosRezinovsky]

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