01-29-2019 12:40 PM
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
01-29-2019 02:05 PM
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:
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!