Forum Discussion
Solved
Employee Utilization Rate - Incorrect Roll-up to month level when calculating Expected Hours
Dear all, I’m calculating employee utilization rates as the proportion of billable hours (actuals), divided by the Expected Hours (projected) minus Leave-hours (actuals): [Billable_Hrs]/([Expected_...
Dear all,
I found a solution in the following thread:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Include-Employee-start-and-end-date-in-Utilization/m-p/743723#M2415Best regards, Martijn
Dear Yadong, Thank you so much for your reply.
Unfortunately I haven't been able to get the desired result with the use of the ALL() function.
I did make a demo-pbix file, modeled after my actual data with copied measures and tables:
https://www.dropbox.com/s/q4asl41bklzzsib/Expected_Hrs_September.pbix?dl=0
If you, or anyone else, would like to take a look, that would be much appreciated!
Best regards,
Martijn