Power BI - Matrix Table - Total row (bottom) in Average value, but total column (right side) in Sum.

[rahalim]

I had difficulties to create matrix table which is the total in row (bottom) should be in Average values, but  the total in column (right side) should be in SUM. 

I had tried searching the solution in few websites, most of the solution in DAX with long and complicated formula which i could not understand.

The is a way in values dropdown to change either SUM or Average values, but it will change to row and column totals as well..

I just thinking, if the matrix table could custom the dropdown individually so that we can select the values in Average for total row and could select the value in SUM for total column or vice versa.

I dont know if it could be done or there is already has the other simplest way instead of long and complicated formula in DAX.

any suggestion or solution?

Thank you in advance.