Forum Discussion

amjenkens's avatar
amjenkens
Regular Visitor
4 years ago
Solved

Calculate a Response Rate

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

Need Help
  • SivaMani's avatar
    SivaMani
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    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