Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help writing an expression

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. ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)