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] ) )
    )

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.