Forum Discussion
Subtotal On Matrix Visual Not Adding up
I am having a problem with subtotals on a matrix visual. I did not use any measures and just dragged the fields from the data which counts the number of students in each given category. The Grand Total is correct, but the total for each school does not add up to the totals.
Hi dc52 ,
Based on my testing, the total for each school has added to the total.
Drag the field into the matrix visual.
The school total is added.
Try to check if having the filter or slicers applied to the matrix visual.
Besides, try to review the aggregation field. Power BI defaults to sum the numeric fields.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
dc52 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Also: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community
I am not currently using any DAX measures for this table. It is just a COUNT of variables I placed in the Values field
Hi dc52 ,
Based on my testing, the total for each school has added to the total.
Drag the field into the matrix visual.
The school total is added.
Try to check if having the filter or slicers applied to the matrix visual.
Besides, try to review the aggregation field. Power BI defaults to sum the numeric fields.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
