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

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        newhopepdx 

        Just to distinguish between newly created columns and original data model measures.