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
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!
Solved! Go to Solution.
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
84 | |
76 | |
64 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |