Calculated Measure Not Changing with Filter

[SonyaJ]

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?

[sevenhills]

 

=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"))

[SonyaJ]

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.

[sevenhills]

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

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/HR-Analytics-Active-Employee-Hire-... 

[SonyaJ]

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?

[sevenhills]

We dont have your data or .pbix file and cannot say correct DAX.

It is not hard. Filter the year and month and other columns using ALL or ALLSELECTED with SELECTEDVALUE.

~ Check the first link and download the .pbix file and look the New Hires page.

Check "isNewHire" and "New Hires". 

 OR 

Check this link, it also has the same 

https://community.fabric.microsoft.com/t5/Desktop/Employee-Turnover-with-Date-Hierarchy/m-p/558408