Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Distinct Count - Active Headcount

Hello Community,   I am using below measure for active headcount for the month , which is working fine   Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Dat...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

     

    Current Employees = CALCULATE(DISTINCTCOUNT(Employee[Employee Id ]) , (FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date])))),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

 

Current Employees = CALCULATE(DISTINCTCOUNT(Employee[Employee Id ]) , (FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date])))),CROSSFILTER(Employee[Start Date],'Date'[Date],None))