Forum Discussion
See all rows in tabel visualisation
Anonymous - Well, it really shouldn't matter which one you choose. Keep the bridge table column and try changing those relationships to single direction versus Both.
Anonymous - The sample data does not say many-to-many to me but will assume that your larger dataset does. Avoid many-to-many if at all possible. Use a bridge table. You can create one like this:
Bridge Table =
DISTINCT(
UNION(
SELECTCOLUMNS('Table 1',"ID",[ID]),
SELECTCOLUMNS('Table 2',"ID",[ID]),
)
)Hi Greg_Deckler
I tried doing this and the data still only allows me to select many to many relationship which is odd.
Is there a reason for this?
Thank you for your help
Anonymous - It's really, really hard to say without seeing how everything is configured and laid out. Any screen shots you could post of what you are seeing and how the visuals are configured would be extremely helpful. Can you share the PBIX? Can you share a mock-up PBIX of your data where we can witness what you are seeing? These things are notoriously difficult to troubleshoot. I don't even know what exactly your calculation is.
The screen shot as well as the attached PBIX file (below sig) Page 35, Table (35) and Table (35a) show that it is indeed possible to achieve:
Hi Greg_Deckler
Let me try to explain it in a different way.
This is what I see on my end. The connection from Datasheet to cable schedule works fine. I am currently trying to show the values of the RunAmp from the loadlist for Tag number (unique values) which matches the Cable Number (has duplicates) from the Load List. The Cable Schedule has items which is not in the Tag number of the loadlist and the loadlist also has items which is not in the Cable Schedule.
But when I do that, each and every value of the RunAmp is being printed out for every single row.
I am unable to share my pbix as it contains sensitive information.
Thank you very much for your help.