Forum Discussion

Vishal7012's avatar
Vishal7012
Regular Visitor
3 years ago
Solved

Resignation count

Hi,   I'm trying to get the count of employees who are serving notice period as of today from the database. Primarily, if the last working date of an employee is beyond today, it should count as th...
  • Anonymous's avatar
    Anonymous
    3 years ago

    oh my bad 

    Count =
    VAR _table = SUMMARIZE(FILTER('Table','Table'[Last Working date] <>BLANK()),'Table'[Employee Id],"Terminated",[Terminated])
    Return
    COUNTROWS(FILTER(_table,[Terminated] = "Yes"))
Vishal7012's avatar
Vishal7012
Regular Visitor
3 years ago

Thanks. There is a syntax error i'm getting while i use the count DAX wherein i'm unable to get the "terminated". Just doesnt seem to identify

Calculate(distinctcount([terminated column]),terminated = "yes") 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

oh my bad 

Count =
VAR _table = SUMMARIZE(FILTER('Table','Table'[Last Working date] <>BLANK()),'Table'[Employee Id],"Terminated",[Terminated])
Return
COUNTROWS(FILTER(_table,[Terminated] = "Yes"))
  • Vishal7012's avatar
    Vishal7012
    Regular Visitor
    3 years ago

    thanks, this works!