Forum Discussion

newhopepdx's avatar
newhopepdx
Resolver I
3 years ago
Solved

Matrix total not average

Visual is a matrix with Venues as rows and months as columns.  Values are attendance totals. Measure calculates the Average monthly attendance. AvAtt = AVERAGEX( 'tblAttendance', 'tblAttendance'[At...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi newhopepdx 

    please try

    AvAtt =
    SUMX (
    VALUES ( 'tblAttendance'[Venue] ),
    CALCULATE ( AVERAGE ( 'tblAttendance'[Attendance] ) )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi newhopepdx 

please try

AvAtt =
SUMX (
VALUES ( 'tblAttendance'[Venue] ),
CALCULATE ( AVERAGE ( 'tblAttendance'[Attendance] ) )
)

  • newhopepdx's avatar
    newhopepdx
    Resolver I
    3 years ago

    Elegant!

    "VALUES", I was trying to configure something with SUMMERIZE and hadn't hit on the right arguments.

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      newhopepdx 

      SUMMARIZE would work just fineand probably more efficient without the need for CALCULATE

      AvAtt =
      SUMX (
      SUMMARIZE (
      'tblAttendance',
      'tblAttendance'[Venue],
      "@Average", AVERAGE ( 'tblAttendance'[Attendance] )
      ),
      [@Average]
      )

      • newhopepdx's avatar
        newhopepdx
        Resolver I
        3 years ago

        Just curious... why the @before the Average? Just a personal convention, or does it have a more important meaning?

        Thanks