Forum Discussion

dc52's avatar
dc52
Frequent Visitor
2 years ago
Solved

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 Gra...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Greg_Deckler
Community Champion
2 years ago

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's avatar
    dc52
    Frequent Visitor
    2 years ago

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