Forum Discussion

pm_barnardos's avatar
pm_barnardos
Frequent Visitor
7 years ago
Solved

Response Rate

Hey there,   I'm very new to Power BI, so I'm sure this is simple however I can't work it out. I need to make a simple response rate calculation column whereby I'm dividing the count of donors by t...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Ah shoot, sorry. Force of habit! (I use variations of the formula I gave you a lot). Just remove the -1

    Response Rate = DIVIDE(COUNTA(Spring18[Donors]),AVERAGE(Spring18[Number Solicited]),0)

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm a little confused. Can you send a screenshot of the table(s) where the two columns are?

pm_barnardos's avatar
pm_barnardos
Frequent Visitor
7 years ago

No problem, here you go:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Update the Number Solicited column to a whole number and create the below measure:

    Response Rate = DIVIDE(COUNTA(Spring18[Donors]),AVERAGE(Spring18[Number Solicited]),0)-1

    • pm_barnardos's avatar
      pm_barnardos
      Frequent Visitor
      7 years ago

      Thanks for you help with this! The formula gives a result, although it still doesn't look right - see below. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ah shoot, sorry. Force of habit! (I use variations of the formula I gave you a lot). Just remove the -1

        Response Rate = DIVIDE(COUNTA(Spring18[Donors]),AVERAGE(Spring18[Number Solicited]),0)