Explain Related() And Relatedtable()?

1.	Explain Related() And Relatedtable()?
Answer» RELATED works when you have a row context on the table on the many SIDE of a relationship. RELATEDTABLE works if the row context is active on the one side of a relationship. It is worth noting that both, RELATED and RELATEDTABLE, can traverse a long chain of relationships to gather their RESULT; they are not limited to a SINGLE hop. RELATED works when you have a row context on the table on the many side of a relationship. RELATEDTABLE works if the row context is active on the one side of a relationship. It is worth noting that both, RELATED and RELATEDTABLE, can traverse a long chain of relationships to gather their result; they are not limited to a single hop.

Answer»

RELATED works when you have a row context on the table on the many SIDE of a relationship. RELATEDTABLE works if the row context is active on the one side of a relationship. It is worth noting that both, RELATED and RELATEDTABLE, can traverse a long chain of relationships to gather their RESULT; they are not limited to a SINGLE hop.

RELATED works when you have a row context on the table on the many side of a relationship. RELATEDTABLE works if the row context is active on the one side of a relationship. It is worth noting that both, RELATED and RELATEDTABLE, can traverse a long chain of relationships to gather their result; they are not limited to a single hop.

Discussion

No Comment Found

Related InterviewSolutions

Dax Nested Functions Is Equivalent To Sql What?
What Is The Difference Between Having A Measure As A Second Filter Param And Having The Original Measure Expression As A Param. Filter(table, [measure]) Vs Filter(table, Sum(...))?
Why Don't You Use A Calculate() In The Aggregation Expression Of A Summarizecolumn()?
What Is The Initial Filter Context?
How Does Summarizecolumns Relate To Filtering?
How Can You Propagate Row Context Through Relationships?
How Are Filter Contexts Created?
How Are Row Contexts Created?
What Is The Difference Between Max And Maxa Functions In Dax?
How Does Calculate() Result In Context Transition?