Regular Visitor
Posts: 40
Registered: ‎10-31-2018

Incorrect Totals when using Bridge tables



For some reason PowerBI is calculating an incorrect value in the Totals row for my tables.

I believe this has something to do with my bridge tables but not able to pin down exactly where the error is.


I have two bridge tables P2 level - for this table visualization the totals are correct

The other bride table - Country, here the totals are appeaing incorrect for $ Value Diff.


The column header is named $ Value Diff.


I have attached a sample workbook here


Super User
Posts: 10,774
Registered: ‎07-11-2015

Re: Incorrect Totals when using Bridge tables

Very likely a measure total problem although it may involve the filter direction of your relationships between your fact and bridge tables. If this involves a measure, see my post about it here:

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!