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
    5 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
Community Champion
6 years ago

Anonymous - You might have an option, if you click on the drop down in the Visualizations pane of a column to "Show items with no data". That might help. Otherwise, you might do this:

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(ISBLANK(__Calc) || __Calc="",0,__Calc)