cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pm_barnardos Frequent Visitor
Frequent Visitor

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 the number solicited for each segment and display as a %, any help appreciated, thanks!

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jd009 Member
Member

Re: Response Rate

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)

 

View solution in original post

8 REPLIES 8
jd009 Member
Member

Re: Response Rate

Are the Count of Donors and Number Solicited fields measures or columns?

Try adding the below measure if measures:
=DIVIDE([Count of Donors],[Number Solicited),0)-1

If columns
=DIVIDE(SUM(Count of Donors),SUM(Number Solicited),0)-1

pm_barnardos Frequent Visitor
Frequent Visitor

Re: Response Rate

Thanks for the reply, I think they columns - the count of donors is a count function and number solicited not summarized. 

 

I get this error using the measure formula:

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 26, [Number Solicited),0)-1)).

 

And this error using the columns formula:

The syntax for 'of' is incorrect. (DAX(DIVIDE(SUM(Count of Donors),SUM(Number Solicited),0)-1)).

jd009 Member
Member

Re: Response Rate

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

pm_barnardos Frequent Visitor
Frequent Visitor

Re: Response Rate

No problem, here you go:

 

screenshot.png

jd009 Member
Member

Re: Response Rate

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 Frequent Visitor
Frequent Visitor

Re: Response Rate

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

 

Screenshot2.docx.png

Highlighted
jd009 Member
Member

Re: Response Rate

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)

 

View solution in original post

pm_barnardos Frequent Visitor
Frequent Visitor

Re: Response Rate

That works! Thank you so much.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors