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.

    6-26Subtotal On Matrix Visual Not Adding up.pbix30 KB
Anonymous's avatar
Anonymous
Not applicable
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.

6-26Subtotal On Matrix Visual Not Adding up.pbix30 KB