Forum Discussion

NickProp28's avatar
NickProp28
Post Partisan
5 years ago
Solved

Relationship between tables

Dear Community,   I do not have unique values in my table, so I having problem on the link relationship.  After reading this post, and followed the steps. But still I encounter the same issues.  ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, NickProp28 

     

    It’s my pleasure to answer for you.

    According to your description, Many-to-many relationships can easily lead to many problems. Maybe you can create a bridge table and then establish two many-to-one relationships.

    Like this:

     

    Table = DISTINCT(UNION(DISTINCT(Table1[category]),DISTINCT(Table2[category])))

    Reference:Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Docs

    Here is my sample .pbix file.Hope it helps.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, NickProp28 

 

It’s my pleasure to answer for you.

According to your description, Many-to-many relationships can easily lead to many problems. Maybe you can create a bridge table and then establish two many-to-one relationships.

Like this:

 

Table = DISTINCT(UNION(DISTINCT(Table1[category]),DISTINCT(Table2[category])))

Reference:Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Docs

Here is my sample .pbix file.Hope it helps.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.