Forum Discussion
Employee head Count and Slicers
Hi Everyone,
I am new to PowerBI and slowly learning.
I have setup sharepoint to house monthly excel files that contain employees for that month.
I created a fiscal information table which is from July 2024 to june 2025.
Everything is working when I slice from month I get the correct count and all data matches...when I slice by Quarter or year it just adds all the months together and the head count is now all the months put together for that year or quarter. I cannot get a single file with all the employee data..I can only get it in multi files with employee information in that file for that month.
here is what my current setup looks like:
for the headcount I have card visual and the measurement is this:
COUNTX('Employee Data','Employee Data'[DataDate])
Employee Data[DataDate] has the year and month for the file date. I use that to confirm what month/year the file came from.
I need to be able to slice via year/quarter/month
I am new to this and looking for any help, been at this for a month lol
appreciate it
i think you should not count date. You should distinct count something like employee ID or employee name
7 Replies
pls provide some sample data and expected output
Thank you Ryan
ex:
headcount for 2025/Q1/JULY was 456headcount for 2025/Q1/AUG was 438
when I select the slicer to show 2025/Q1 the headcount is wrong, it adds both july and aug together. Each file I add every month has duplicate users so its almost like I need to filter by the DataDate column while doing the count x since the date is required.
I have attached some screenshots of my visuals and the results
I want to see the average employee headcount only when Quarter or year is select and the visual to display accordingly.If you don't want the duplicated users, then you can use DISTINCTCOUNT to remove duplicates.
