How to make a rate measure respond to a slicer?

[mckennaodonnell]

Hello, 

Requirement

Determine the response rate of attendees from an event and have it update when an event is updated in a slicer. When it is filtered and not filtered. 

I am attempting to make a measure respond when a slicer is selected. When it is de-selected, the measure calculates with the "Select All". how do I get the rate formula to respond when it is filtered by Event Name? How do I get the formula to return a blank when nothing is selected?

The Card hosting my response rate KPI is 

ResponseRate = DIVIDE([Total Survey Respondents],[Total ExAttendees], "N/A")

the denominator is:

Total Attendees = CALCULATE(SUM('Events'[countParticipants]),FILTER(Respondees,Respondees[Event ID]=
    SELECTEDVALUE('Respondees'[Event ID]))) 

the numerator is:

Total Survey Respondents = DISTINCTCOUNT(Attendess[Attendee Name])

[v-jialluo-msft]

Hi  @mckennaodonnell ,

You can try this measure:

ResponseRate =
DIVIDE (
    IF ( ISFILTERED ( 'Respondees'[Event ID] ), [Total Survey Respondents], 0 ),
    [Total ExAttendees],
    "N/A"
)

If that's not what you need, upload a sample file.

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mckennaodonnell]

Thank you! @v-jialluo-msft How do you get it it calculate in the measure when it is not filtered?