Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm trying to write an expression for a vacancy no response rate.
Basically, I have a column with 75 unique vacancy reference numbers, and a column saying how many CV's were sent to each.
I want to make a measure which calculates the percentage figure of 0 Cvs sent over total rows.
Would look something like = count Number of Cvs sent=0 / count rows
Solved! Go to Solution.
Hi @Anonymous ,
Try this measure.
Hi @Anonymous ,
Try
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @harshnathani I appreciate the response, however I think I might not have explained myself clearly enough.
I just want a % of vacancies we didn't respond to.
e.g. in your table the final value would be 25%.
Hi @Anonymous ,
Try this measure.
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |