Subtotals Matrix not adding up

dc52 — Wed, 03 Jul 2024 14:09:23 GMT

Hello Community!

I am having a problem with subtotals in PowerBI for the matrix visual. I DID NOT use any measures but instead just dragged the fields into the rows, columns and values section of the visual itself, using count of Student IDs as the value itself. While the grand total is correct, the subtotals for each given school (Hierarchy) are not adding up to that grand total which is correct. The image is shown below.

Any tips or ideas why this would be?

Re: Subtotals Matrix not adding up

Greg_Deckler — Wed, 03 Jul 2024 14:12:24 GMT

@dc52 Did you use Count or Distinct Count? When you aggregate on a column, you are in fact using an implicit measure so it's essentially the same as if you had used a measure.

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

topic Subtotals Matrix not adding up in Custom Visuals Development Discussion

Subtotals Matrix not adding up

Re: Subtotals Matrix not adding up