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.
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.
Community ChampionAnonymous - Ah, your bridge table still contains duplicates. This can happen in certain circumstances when you have a text-based key. Did you use DISTINCT? I think it can still happen though depending upon casing or there is some other hokey reason for this. Also, your relationship direction from your bridge table is not correct for the right-hand table, it should be pointing the other direction or Both <>.
Hi Greg_Deckler ,
I used
Bridge Table =DISTINCT(UNION(SELECTCOLUMNS('Cable Schedule',"ID",[Cable Number]),SELECTCOLUMNS('loadlist',"ID",[Tag Number])))I have changed the relationship and I still get the result below being repeated for every single row. The numbers on the right is the RunAmp.I cant seem to just get the value for that which matches the Cable Name.
- Greg_Deckler
Anonymous - Is your ID column text or numeric? Can you provide me a sample of the values there or just examples of what they look like? DAX has a nasty case insensitivity habit.