Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
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)
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
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)).
I'm a little confused. Can you send a screenshot of the table(s) where the two columns are?
No problem, here you go:
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
Thanks for you help with this! The formula gives a result, although it still doesn't look right - see below.
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)
hello, may I know why you used average?
That works! Thank you so much.
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |