Incorrect Totals when using Bridge tables

Question

Hello&nbsp;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.&nbsp;I have two bridge tables P2 level - for this table visualization the totals are correctThe other bride table - Country, here the totals are appeaing incorrect for $ Value Diff.&nbsp;The column header is named $ Value Diff.&nbsp;I have attached a sample workbook herehttps://drive.google.com/open?id=1uiVYCRAug1z-DFyOW7mqgoQZh2geGZfw&nbsp;

greg_deckler · Answer

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

Forum Discussion

Incorrect Totals when using Bridge tables

1 Reply

Related content

Incorrect turnover total

Measure Total Incorrect

Bridge Table Dax Help

Matrix Totals Incorrect

Incorrect total