power bi dax add related shows column but not working
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