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...
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?
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