Forum Discussion
Totals in Matrix Table
Hi, I've been trying to resolve this issue no success. I am using the following measure
StaffSplit = calculate ( sum ('staff cost'[£]) * calculate ( sum ('staff allocation by BU'[%])))
In the following table
As you can see, the rows and subtotal are adding up OK, but the grand total is doubling up all rows. How should my measure be amended to correct this?
This looks like a measure totals problem. Very common. 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
1 Reply
This looks like a measure totals problem. Very common. 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