The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
one of my table has Many to Many cardinality, and when I try to use RELATED , the option to select coloumn from that table is not there; this means that RELATED cannot work with Many to Many relations, is that a correct assumption.
Thanks,
Siddharth
Solved! Go to Solution.
yes, related() can not understand what column is relatedin many-to-many relationships
See remarks here https://docs.microsoft.com/en-Us/dax/related-function-dax
hi @siddharthj
RELATED function returns a related value from another table.
For your case, it is a Many to Many cardinality, so you may try RELATEDTABLE Function to create a column as below:
MAXX(RELATEDTABLE('Table'),[Column])
or create a column as below:
CONCATENATEX(RELATEDTABLE('Table'),[Column],",")
Regards,
Lin
yes, related() can not understand what column is relatedin many-to-many relationships
See remarks here https://docs.microsoft.com/en-Us/dax/related-function-dax
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
70 |