Forum Discussion
Bridge Table Inquiry
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.
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-tabular/
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,
4 Replies
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.
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-tabular/
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,
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?
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?
