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
Hi MEverts ,
Please use ALL( ) function.
ALL( ) returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.
For more information, please refer to:ALL function (DAX) - DAX | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.