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 is not a very common function to use if you build a good data model and good DAX. There is a lot to learn. Unlike Excel, the relationships are normally modelled in the model view and most of the rest can work from there without using the related function. But of course it depends what you are trying to do.
my article here should help you get started. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/