Forum Discussion
Calculate + UseRelationship Syntax with N to N
Hi mpros,
Your relationship likely doesn't work just because you are using a Many-to-Many relationship. There are a LOT of nuances to using this type of relationship, and this could easily be affecting whether the UseRelationship dax function is allowed to work.
This post from amitchandak has a possible solution: Solved: USERELATIONSHIP and many to many - Microsoft Fabric Community
Also, your many-to-many relationship is Limited. This can also affect the useability of UseRelationship. To see what this means, look here:Model relationships in Power BI Desktop - Power BI | Microsoft Learn under "Limited Relationships (it's about half way down).
Hi mpros,
Your relationship likely doesn't work just because you are using a Many-to-Many relationship. There are a LOT of nuances to using this type of relationship, and this could easily be affecting whether the UseRelationship dax function is allowed to work.
This post from amitchandak has a possible solution: Solved: USERELATIONSHIP and many to many - Microsoft Fabric Community
Also, your many-to-many relationship is Limited. This can also affect the useability of UseRelationship. To see what this means, look here:Model relationships in Power BI Desktop - Power BI | Microsoft Learn under "Limited Relationships (it's about half way down).