Averaging instead of Total in Matrix

[abukapsoun]

Hi,

I have the following dataset

And I want to display it using a matrix instead, 

However, instead of showing the row total as a sum of values P01 + P02, I want to display the average of them.

How can I achieve this?

Many thanks in advance.

[rocky09]

Click on the Values on the visual option then select average? Is that you wanted?

[abukapsoun]

Hi

i tried that, but that will then mess the values in column P01 and P02

[v-chuncz-msft · Accepted solution]

@abukapsoun ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310...