Forum Discussion

bigrods's avatar
bigrods
Helper III
5 years ago
Solved

Filter Many to Many relationship by field

Hi,   I have an issue with trying to get my data together that I hope someone could help with and I can explain adequately!   I have 2 tables: Referrals and Caseload. The Referrals table is a li...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi bigrods 

    Many-to-many relationships can cause a lot of problems, which is why it is also called a weak relationship. In most cases, it can be solved by creating a shared dimension and creating a one-to-many relationship from the shared dimension to the fact table. Avoid this type of relationship in your model. The current scenario is more suitable for sharing dimensions.

    I found an article about one to many and many to many relationship between tables ,you can make some changes through this article .

    https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified

     

    Best Regards

    Community Support Team _ Ailsa Tao

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

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

I suggest you create dimension tables for the fields common to both tables and create one-to-many relationships. You can then use these dimension tables in your filters, slicers measures etc...

It is highly recommended to avoid many-to-many relationships since they can produce unexpected (and hard to detect) results.