Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Count of active employees between two dates, by department

I want to replicate the bundle of reports on the following page, particularly the Demographic Analysis report.

 

My data has Employee ID, Department ID, Hired Date, Termination Date, Terminated Y/N and all the pertinent columns.

 

I have found solutions online that do show number of active employees per date organization-wide, but I'm not sure how I can filter them by department. Would I have to create separate measures for each department? And if so, would that work with the departmental slicer I have?

 

Thanks!

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Anonymous ,

 

you do not have to create a measure for each department, of course you can leverage the department slicer.

As you deal with snapshot data or semi-additive measures (as headcount can not be summed over time) your measures become more complex. This article describes how to create semi-additive measures: Semi-Additive Measures in DAX - SQLBI

Hopefully, this provides some ideas on how to tackle your challenge!

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

Hey @Anonymous ,

 

you do not have to create a measure for each department, of course you can leverage the department slicer.

As you deal with snapshot data or semi-additive measures (as headcount can not be summed over time) your measures become more complex. This article describes how to create semi-additive measures: Semi-Additive Measures in DAX - SQLBI

Hopefully, this provides some ideas on how to tackle your challenge!

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.