Forum Discussion
Issues with bridge table
I'm using a bridge table to solve a many-to-many relationship issue but am now running into another issue. I should have 9 amounts showing, but when I add a field from the table on the other side of the bridge that only has a value for one of my amounts, my visual table only shows one row. If I turn off the summarize feature then it tells me it cannot determine a relationship until I select show items with no data. But instead of the new field having blanks, both the amount and new field show blank. I've attached pictures. Some information is cut off but you can still see what is happening.
4 Replies
Without a more specific set of example data, this looks like a general many to many relationship issue. A bridging table used to be the old method of solving this issue, but now you can just create a normal many to many relationship. The bridging table just hides the errors you see, it doesn't eliminate them.
You can read more about it on Microsofts page regarding Many to Many relationships.
If you could share more about the problem you're trying to solve, we could suggest alternative solutions that avoid many:many relationships in the first place.Unfortunately, I think I am stuck with many to many based on our data. I am using the bridge table because the native many to many functionality wasn't letting me use a calculation to have tables remain blank until at least one ID was selected. This worked once I used the bridge table instead.
Why would Power BI remove the values that are matched though instead of leaving them there? I fully understand making the Note field blank if there is no note for an ID, but I can't understand removing the amounts when there is an amount. Also, any idea why you can't remove summarization? Once I do that it says no relationship is found.
Hi Anonymous
you might consider to create a pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file(Not just screenshot). Please do not forget to describe the expected results based on this sample data.
