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

Hi Tlotly 

 

Are you using AVERAGE? You should use AVERAGEX instead

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])))
     
    • Tlotly's avatar
      Tlotly
      Icon for Helper V rankHelper V
      3 years ago

      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.