Forum Discussion

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.

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

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)

3 Replies

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

Related content