Measure to calculate Average for Column subtotals and Total for Row subtotals

[Anonymous]

Hello,

I am trying to create a measure that will show the data, below, which is an average calculation in each cell. However, the "total" on the right should be the average of the current row. The "Total" on the bottom should be the total of the column. In the example below, the totals at the bottom are correct, but the ones on the right are totalling instead of averaging.

[Mariusz · Accepted solution]

Hi @Anonymous 

Please see the below DAX Expression 

AVG of an avarage = 
AVERAGEX( 
    GROUPBY( 
        YourTable, 
        YourTable[Matrix Rows], 
        YourTable[Matrix Columns]
    ), 
    CALCULATE( AVERAGE( YourTable[Value] ) ) -- this can be replaced with Measure
)

Regards,
Mariusz

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