Question : power bi dax add related shows column but not working
Answered by : jessica-koekemoer
The related function does not work with Many to Many relationships.
Solution – You can either:
a) Work with one to many relationship
b) Use Power Query to join the two tables
c) Or try to use the LOOKUPVALUE function to retrieve the lookup value
Source : https://www.goodly.co.in/dax-related-function-not-working/ | Last Update : Fri, 26 Feb 21