Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

See all rows in tabel visualisation

Hi all,   I am trying to combine 2 tables into 1 from 2 different sources. When I made the relationship and try to use the table visualisation, not all the IDs is being displayed, is there any way...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - 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 <>.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.