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

Incorrect Totals when using Bridge tables

Hello

 

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

https://drive.google.com/open?id=1uiVYCRAug1z-DFyOW7mqgoQZh2geGZfw

 

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: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


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

Proud to be a Datanaut!