Bridge Table Inquiry

[Andrewsinger]

Currently I am attempting to create a relationship between two individual tables so that I can sync my filters onto my actual numbers and have my data reflect the proper numbers with said filters. When I try to straight up create a relationship it creates a many to many relationship which **bleep**s up all my data. I then tried to use a bridge table but they have different amounts of columns so that doesnt work either. I would love anything that can point me in the right direction. I can provide more information if needed. Thanks. 

[Andrewsinger]

Currently I am attempting to create a relationship between two individual tables so that I can sync my filters onto my actual numbers and have my data reflect the proper numbers with said filters. When I try to straight up create a relationship it creates a many to many relationship which **bleep**s up all my data. I then tried to use a bridge table but they have different amounts of columns so that doesnt work either. I would love anything that can point me in the right direction. I can provide more information if needed. Thanks. 

[ibarrau · Accepted solution]

Hi. I don't I totally follow the issue. You have a many to many relationship, are looking to avoid that? change it? or you want it but doesn't work.

I would say that the best is to avoid bidirectional filter or many to many, but there are scenarios that might be usefull. I think this article talking about many to many might help understanding the theory that might help on the practice: https://www.sqlbi.com/articles/different-options-to-model-many-to-many-relationships-in-power-bi-and...

If the problem is data duplication and many to many you will need to analyze your data to understand which are the duplicated values that won't allow the 1 to many. Deep dive in your data to get to know it. That way you will find what's odd and if it correct that works that way.

I hope that helps,

[lbendlin]

Ideally you want to have your dimension table control your fact table in a 1:* single direction relationship.  Anything deviating from that is considered sub-optimal.  

Can you qualify the tables as either facts or dimensions?  Are they mixed?  Do you have multiple fact tables?

[Alex_Sawdo]

Can you share some more details about your data model, such as table structure and what data is stored in the columns you're trying to create a relationship with?