Forum Discussion
Related() issue
RELATED doesn't works because DAX is based on Expanded tables concept, where each table on the one side of the relationship expands to the related table on the many side, just like LEFT join in SQL, and RELATED only allows you to access columns of an expanded table, but table expansion doesn't happens in case of many to many relationships. so you will have to either create a bridge table, or create dimensions properly or you use something like this :
= MINX ( RELATEDTABLE ( Table ), Table[ColumnName] )
Community ChampionRELATED doesn't works because DAX is based on Expanded tables concept, where each table on the one side of the relationship expands to the related table on the many side, just like LEFT join in SQL, and RELATED only allows you to access columns of an expanded table, but table expansion doesn't happens in case of many to many relationships. so you will have to either create a bridge table, or create dimensions properly or you use something like this :
=
MINX ( RELATEDTABLE ( Table ), Table[ColumnName] )
Thank you! This actually worked 🙂