Help writing an expression

[Anonymous]

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

[harshnathani]

Hi @Anonymous ,

Try 

CV Sent% =

var b = CALCULATE(SUM('Table'[CV's Sent]),ALL('Table'))

RETURN

DIVIDE(MAX('Table'[CV's Sent]),b)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

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%.

[harshnathani · Accepted solution]

Hi @Anonymous ,

Try this measure.

Did not respond =

Var a = CALCULATE(DISTINCTCOUNT('Table'[Ref No]),ALL('Table'))

var b = CALCULATE(COUNT('Table'[CV's Sent]),KEEPFILTERS('Table'[CV's Sent] = 0))

var c = COUNTROWS(FILTER('Table','Table'[CV's Sent] = 0))

RETURN

DIVIDE(c,a)

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)