Forum Discussion

PaulCo's avatar
PaulCo
Helper II
8 years ago
Solved

Survey Response Rate

I'm pulling survey data from SFDC where a table diplays a survey score if a response has been received from a customer.    I want to create a measure of the percentage of customers that have respon...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

     

    PaulCo

     

    Hi, try with this measure

     

    Response Rate =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( Table1[Customer] ),
        FILTER ( Table1, Table1[Score ] <> BLANK () )
    ),
    DISTINCTCOUNT ( Table1[Customer] )
)

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

 

PaulCo

 

Hi, try with this measure

 

Response Rate =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( Table1[Customer] ),
        FILTER ( Table1, Table1[Score ] <> BLANK () )
    ),
    DISTINCTCOUNT ( Table1[Customer] )
)

Regards

 

Victor

Lima - Peru

  • PaulCo's avatar
    PaulCo
    Helper II
    8 years ago

    Perfect, just what I needed, Thanks!