Matrix Totals - Show as average instead of SUM

[JimJim]

Hi Guys,

I have a strange request from a stakeholder, I have the following matrix:

Is it possible to show the column totals as average? I have attached a link to a test report:

https://1drv.ms/u/s!ArazqhFmvkSJlmVxJRRpSR1dAG4m?e=R602o4

[daXtreme · Accepted solution]

Yes, it's possible.

If you want to have fancy formatting, then you have to use CALCULATION GROUPS. Or, you can remove the decimal part from all the numbers. But then your averages will be rounded  to integers according to PBI rules. This is the easier option.

[JimJim]

Amazing, thank you