Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |