How to change total column sum to average in matrix?

[scherd]

Hi,

I am trying to take average of row values rather than sum in matrix.

I have seen https://community.powerbi.com/t5/Desktop/Median-of-Row-Column-in-Matrix/m-p/58209#M23837 this post

which is totally what I intended to solve, but it changes row values as well.

I want to keep row values, and only change the total column sum to average in row based.

If anyone has an idea, I would be grateful.

[v-micsh-msft]

Hi scherd,

Only change the calculate type of the total column is not available currently in Matrix under Power BI.

Total column and total row in Matrix calculate the same value field, change the calculate method of the value field will affect both of them.

We may consider submit an idea on this topic, through the following website:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards