Forum Discussion
Matrix Subtotals Different calculation....
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
HI TheCAKurtle,
So your matrix is designed based on UWI fields and multiple measure formulas?
AFAIK, measure formula with specific filters and conditions can not work properly on the visual total level with aggregated features.
In my opinion, I'd like to suggest you take a look at Greg_Deckler's 'measure total calculation' blogs to know more about this scenario, do modification to add if statement checks the current row contents level and write a total level expression to your measures to manually handle the total level calculation.
If you still confused about coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin SHeng