Total average of average

[Tlotly]

Good day

Is it possible to get the total to show the correct average total in a matrix?

In the example below, total average should be 53.75, not 52

Thank you in advance.

[mlsx4]

Hi @Tlotly 

Are you using AVERAGE? You should use AVERAGEX instead

[Tlotly]

Hi @mlsx4  yes I'm using average.

But I tried using avergaex, still getting the same results:

   Measure = AVERAGEX('Centre Attendance', 'Centre Attendance'[Percentage_Attendence])

[mlsx4]

HI @Tlotly 

Your measure should be:

Measure= AVERAGEX(VALUES('Centre Attendance'[Region]),CALCULATE(AVERAGE('Centre Attendance'[Percentage_Attendence])))

[Tlotly]

Thank you @mlsx4. Your measure works perfectly. The only problem I'm having now is the regions drill down from zone to the centre level so it doesn't work on those levels.