Forum Discussion

newhopepdx's avatar
newhopepdx
Icon for Resolver I rankResolver I
2 years ago

Monthly average greater than the largest single input. Why?

I have started an event attendance report showing total attendance by event date to various events and a bar graph showing the average monthly, quarterly or yearly total attendance per event date.  ...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

Because you are taking the average at the venue level then adding those all up:

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

The first one is just the straight avg so you can see that it is correct at the venue level.  Then you add all those up and get 847.

  • newhopepdx's avatar
    newhopepdx
    Icon for Resolver I rankResolver I
    2 years ago

    Ok, I see how that work, but then what is the proper measure definition?