How to: Multiple Active Relationships

Hi. There is no way to have two activated relationship between two tables. For this case you need to think which of them are just for one calculation and which one is for filter propagation. If you understand the relationship for just a value calculation, you can use an inactive relationship for a measure.

Check this articule to get a better understanding on how to solve this.

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Regards,

AlainD 

It is impossible to have multiple active relationships between two tables, However, you can use inactive relationship in your DAX with USERELATIONSHIP. 

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

Best, regards 

Paul Zheng

Hi ibarrau & Anonymous,

Thank you for the answers, it's unfortunate that it is not possible the easy way and I havent got it to work with both solutions offered yet. I must take a little bit more time since power bi is still very new to me. 

Will revert back once I get it to work or give up.

Thank you