Average from Matrix Total

[Sime]

Hi All,

I'm struggling to obtain the yearly average, (current and previous years), from the row totals in a Matrix grid. 

I had created a measure and applied this to the grid and the monthly averages were correct but the average for the total wasn't even close. 

Any help would be appreciated. 

Thank you.

[Sime · Accepted solution]

Hi v-xiaotang,

Thanks for the reply.  I was able to achieve the expected result by creating a subtotal measure and then using another measure to average this value.

Thanks again.

[v-xiaotang]

Hi @Sime 

Thanks for reaching out to us.

To solve the question, more information is needed.

(1) A sample file, you can replace the raw data with bogus data.

(2) if you are not able to provide a sample file, could you provide some sample data in text? and the measure [KPI Average] you create.

(3) Your expected result. For example, in the picture, the last Average for Total Value is 2.71, it's incorrect. So please specify the correct value based on your sample.

Thanks 🙂

Best Regards,

Community Support Team _Tang

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

[Sime]

Averages are appearing fine for the individual columns but incorrectly for the total.