Forum Discussion
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...
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)
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)
That works! Thank you so much.