Need to total the sum of averages per category HELP

[stlrivals]

I am trying to calculate the sum of averages

Example 

Table below

the category is system pair

I want it to end up looking like this

I get this far in Power BI and can not figure out the string to get the total

[v-denglli-msft · Accepted solution]

Hi @stlrivals,

After placing the /Average of Physical Used(Post Comp) TB/ column into the Values option of the matrix visualization, select its summarization method as /Sum/.

In this way you can see the sum of the average values per category.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.