Forum Discussion
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...
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 ,
One is the max measure on table2 when table 2 is joined with Table 1
Max(Table[value])
Another option is a new column in table 1
MaxX(filter(Table2, Table2[Id] =Table1[Id]), Table2[Value])