Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total in table sums incorrectly

Hi all,   I have a table that shows the number of members for a loyalty card scheme sliced by location:   The weird thing is that the total is correct -- I know that there's 48364 members i...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Bridge table:

 

Table 1 *<---1 Bridge Table 1 --> * Table 2

 

Basically a bridge table is a distinct (unique) list of values in the columns that make up the relationship between tables 1 and 2. You can create it in Power Query or in DAX. In DAX it is:

 

Bridge Table = 
  DISTINCT(
    UNION(
      SELECTCOLUMNS('Table 1',"Column",[Column]),
      SELECTCOLUMNS('Table 2',"Column",[Column])
    )
  )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler 

 

I see! I've looked into this a bit more now and had a play around. I seem to have solved the problem -- you're right it's caused by the many-to-many cardinality in what's a poorly structured data model. I've read up on model structures and rejigged my model into a star schema and it seems to have solved the problem (so far!)

 

Thanks for your help!

H