How to calculate the average of rows in the matrix

[Anonymous]

Hi,
I have a matrix and I need to calculate the average of rows in the matrix for the past 12 months.
The average for 'Actual Exp' will be different than the 'Actual Min' values, and RAG will be calculated based on the average value of 'Actual Exp'.

I don't know how to get the average for 'Actual Exp' and  'Actual Min' in a matrix.
Thanks, guys.

[Anonymous · Accepted solution]

To calculate the separate averages for Actual Exp and Actual Min you can create a table with measures. The formula for the measure is:

Avg_Actual Exp = AVERAGE({Table Name}, {Column Name})

This formula will also consider only the valid values and will omit the text or null values.

For those values which only have null or text values in the rows, the formula is:

Avg_Actual Exp = IF(ISNUMBER(AVERAGEX({Table Name}, {Column Name}), AVERAGEX({Table Name}, {Column Name},"N/A" )

This will give you the "N/A" if the whole row has null values.

You can replicate the same thing for the Actual Min.