Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all,
I have an emloyee table and created a measure called employee count.
Solved! Go to Solution.
Thank you for the idea! It gives diferent numbers but they stil lare not correct and it finds employees who were terminated before they were hired. Using a different measure I can calculate it properly:
@apaulso9 Maybe try this:
Employee Count =
VAR __selectedDate = MAX('Date'[Date])
VAR __Table =
FILTER(
ALL('All Employees'),
[DTHired] <= __selectedDate && ( [DTTerminated] = BLANK() || [DTTerminated] >= __selectedDate )
)
VAR __Result = COUNTROWS(DISTINCT(__Table))
RETURN
__Result
Thank you for the idea! It gives diferent numbers but they stil lare not correct and it finds employees who were terminated before they were hired. Using a different measure I can calculate it properly: