Forum Discussion
Matrix sub total is not adding up properly
Anonymous -
If this is a not a measure, then it looks like you are using Average aggregation, so it is going to average at the subtotal level as well. If you want it to be one thing at one level (aggregation type) and a different aggregation at a different level, you need: MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-Roll/m-p/411443#M150
If this is a measure then 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