Calculate a Response Rate

[amjenkens]

I'm trying to calculate a response rate off of the 2 tables below. One contains the number of attendees at each event and one contains the responses from attendees to a post-survey. How do I calculate the response rate that then filters down by quarter?

This is the list of respondents, each row is a respondentThis is the attendance sheet from each program. There are multiple programs by quarter

[SivaMani · Accepted solution]

@amjenkens, I consider you have keys between these two tables (such as EventId). Create a Relationship between the tables and create the below measures,

1. Response = COUNT(Table1[ResponseID])
2. Participants = SUM(Table2[Attenance])
3. Response Rate = DIVIDE(Response ,Participants )

[Anonymous · Accepted solution]

Hi @amjenkens ,

Please new a table first:

BridgeTable = DISTINCT('Table2'[YearQuarter])

Relationships:

Then new a measure:

Response Rate = 
VAR _attendees = COUNT('Table1'[Respondent ID])
VAR _response = SUM('Table2'[Attendence])
VAR _rate = DIVIDE(_response,_attendees)
RETURN
_rate

Result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[SivaMani · Accepted solution]

@amjenkens, I consider you have keys between these two tables (such as EventId). Create a Relationship between the tables and create the below measures,

1. Response = COUNT(Table1[ResponseID])
2. Participants = SUM(Table2[Attenance])
3. Response Rate = DIVIDE(Response ,Participants )