topic Re: Subtotal On Matrix Visual Not Adding up in DAX Commands and Tips

Subtotal On Matrix Visual Not Adding up

dc52 — Tue, 25 Jun 2024 15:11:33 GMT

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.

Re: Subtotal On Matrix Visual Not Adding up

Greg_Deckler — Tue, 25 Jun 2024 16:26:01 GMT

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

Re: Subtotal On Matrix Visual Not Adding up

dc52 — Tue, 25 Jun 2024 22:29:28 GMT

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

Re: Subtotal On Matrix Visual Not Adding up

Anonymous — Wed, 26 Jun 2024 07:13:14 GMT

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.