Subtotal On Matrix Visual Not Adding up

[dc52]

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. 

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@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/n4TYhF2ARe8

Also: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community

[dc52]

I am not currently using any DAX measures for this table. It is just a COUNT of variables I placed in the Values field