Forum Discussion
I am facing issues in Datamodeling in Power BI
I am having dataset created. here i need to create new relationship between two tables. Inbetween these two tables there is a common column but i cannot create realtionship make the relation ship act...
In Power BI, a table can't have multiple active relationships to the same table. Workarounds for this is to duplicate that table or use DAX function USERELATIONSHIP()
Details in this article: https://www.sqlbi.com/articles/using-userelationship-in-dax/
Anonymous
In case do not want to use dax to include inactive relationship, you could create a bridge table with Distinct or Summarize depends on your requirement.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.