15 - Evaluation Context - Row Context and relationships
Hi Learners,
In this video, I have discussed about the scenarios where Row Context is used with relationships in Power BI.
I have explained their working using calculated columns in the demo. Important point to consider are as below:
RELATED / RELATEDTABLE function:
Both commands are used inside a row context
When you want to propagate the row context from many side to one side, use RELATED
When you want to propagate the row context from one side to many side, use RELATEDTABLE
Both commands can pass through multiple relationships(multiple hops in a relationship)
If you have one-to-one relationship, then both commands work in both scenarios(as one-to-one acts as a one-to-many and many-to-one at the same time).
When you have chain of relationships:
all relationships should be of same type, i.e., one-to-many or many-to-one
If you have three tables, first table having one-to-many relationship with second ,and then second table has many-to-one relationship with third, then neither RELATED nor RELATEDTABLE command works as filter propagates in a single direction(opposite directions).
Only RELATEDTABLE works using bi-directional filter propagation. RELATEDTABLE cannot propagate the relationships if the they are not going in the same direction.
To know more, please watch this video.
To learn more about RELATED/RELATEDTABLE, please visit the link -
• 4 - Table Functions - RELATED and REL...
To learn more about nested row context, please visit the link - https://www.youtube.com/watch?v=GmgK4...
To learn the evaluation context from beginning, please visit the link - https://www.youtube.com/watch?v=Jf7hz...
To learn more about DAX and Power BI, please subscribe to our channel ML For Analytics.
/ mlforanalytics
To know more about our blog and the topics related to business intelligence and data science, please visit the following link:
https://mlforanalytics.com/