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

For visual purpose.

Simply add a new measure 

Today's date = TODAY()

 

now add thisbto yoir visual,

 

Create another measure 

 

Terminated = if(max(table[last working day]) < [Today's Date], "yes","no")

 

Now create a count measure

 

Count measure = 

Var summary = summarize(table,[employee id],"terminated column",[Termintaed]

Return

Calculate(distinctcount([terminated column]),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!