employees under 23 dynamic

[alexcatala]

Hi, I am trying to figure it out the number of employees under 23 who are currently active.

I have the formula for the employees under 23 :

23 age = CALCULATE(COUNTROWS(FILTER('f_Employees',f_Employees[EmpAge] <=23)))

Also, the formula to know the currently active employees:

active2 employees = var currentdate = MAX(d_DateTable[Date])

return CALCULATE(DISTINCTCOUNT(f_Employees[EmplCode]),f_Employees[EmpJoinDate]<=currentdate,or(ISBLANK(f_Employees[EmpLeavDate]),f_Employees[EmpLeavDate] > currentdate))

How can I obtain the number of employees under 23 that are currently active?

Thanks

[amitchandak]

@alexcatala , Please refer to this

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[alexcatala]

@amitchandak I have already the formula for the active employees, but as I am trying to figure it out how many of them are under 23, it might be a different formula.

I used 2 measures to calculate employees under 23 and also to find out the active employees.

Now I only need how to link between them and make it work.

[amitchandak · Accepted solution]

@alexcatala , if age is a column

active2 employees = var currentdate = MAX(d_DateTable[Date])
return CALCULATE(DISTINCTCOUNT(f_Employees[EmplCode]),f_Employees[EmpJoinDate]<=currentdate,or(ISBLANK(f_Employees[EmpLeavDate]),f_Employees[EmpLeavDate] > currentdate),'f_Employees',f_Employees[EmpAge] <=23)

if measure please share formula

[alexcatala]

@amitchandak 

It works!!

Thanks a lot!