Forum Discussion
Calculated Measure Not Changing with Filter
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?
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