I am facing issues in Datamodeling in Power BI

[Anonymous]

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 active.  Getting cardiinality issues asking to remove other relationships to active this relationship. but i required those relations ships as well. What is need to do here.

[V-pazhen-msft]

@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.

[PaulDBrown]

You need to create a new dimension table with unique values convering the range of values for the common field in both tables. You then create a one-to-mamny relationship between the field in the new dimension table and the corresponding fields in each fact table. Use the dimension field in measures, filters, slicers and visuals.

[YukiK · Accepted solution]

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/