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]),FILTER('HR Demographics Data','HR Demographics Data'[NewHire]="Y"))
Any idea on what i am doing wrong?
5 Replies
=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
