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.
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
=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)).