Averaging with gaps in date slicer

[newhopepdx]

The averaging is working as expected until I remove a date from the middle of the selected slicer range. How do I overcome this? The goal would be to be able to not count certain days where the attendance was inflated due to extraordinary situation (like 4/17 which was 826).

Here's a screen shot of the data and the measure (that works without gaps).

Total Attendance =

CALCULATE(

SUM( 'Attendance'[Attendance] ),

DATESBETWEEN('Calendar'[Date],

FIRSTDATE('Calendar'[Date] ),

LASTDATE( 'Calendar'[Date] )),

ALl('Attendance' )

)

As shown in the photo, the # of events has properly reflected the "unselection" of 4/17 whereas the 5888 total attendance hasn't. I realize that that is because of the "ALL('Attendance') filter, but what is the correct way to modify this measure?

Thanks,

Steve

[amitchandak · Accepted solution]

@newhopepdx , I think you need measures like

Total Attendance =
CALCULATE(
SUM( 'Attendance'[Attendance] ),
allselected('Attendance' )
)

Avg By Day =
AverageX(Values('Date'[Date]), CALCULATE(
SUM( 'Attendance'[Attendance] ),
allselected('Attendance' )
) )

[newhopepdx]

That worked! Both measures yielded the correct answer.

Thanks!