Forum Discussion

Tlotly's avatar
Tlotly
Icon for Helper V rankHelper V
3 years ago

Total average of average

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.

 

Need Help

4 Replies

    • Tlotly's avatar
      Tlotly
      Icon for Helper V rankHelper V
      3 years ago

      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's avatar
        mlsx4
        Icon for Memorable Member rankMemorable Member
        3 years ago

        HI Tlotly 

        Your measure should be:

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