Forum Discussion

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver 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] ) )
    )

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver 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
Icon for Community Champion rankCommunity 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
    Icon for Resolver I rankResolver 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
      Icon for Community Champion rankCommunity Champion
      3 years ago

      newhopepdx 

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