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.

Anonymous's avatar
Anonymous
Not applicable
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.