Forum Discussion
Calculated Measure Not Changing with Filter
I am trying to count employees over 2 years, who are new hires using the below formula, however this is only returning data for one month not for the full time. =CALCULATE(COUNT([Employee Id]),FILTE...
=CALCULATE(COUNT([Employee Id]),FILTER( ALL('HR Demographics Data'),'HR Demographics Data'[NewHire]="Y"))
OR
=CALCULATE(COUNT([Employee Id]),FILTER(ALLSELECTED('HR Demographics Data'),'HR Demographics Data'[NewHire]="Y"))
Thanks
Both of these worked, it is now giving a number for each month, however not the correct number. It is giving the number for Jan for every month.
Yes, All or allselected uses all your data in the table. and hence you see the same values in all months.
Not sure if you are building this kind:
https://learn.microsoft.com/en-us/power-bi/create-reports/sample-employee-hiring-history
I am wanting to see the active employees and then of those how many are new hires for the month? How would i do this?
