Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating Employee Productivity

Dear community members,   Need your expert help in the following situation. I have three tables: Hours, Employee, and Project.   The Hours table contains the hours details by each employee for a...
DAX
Help required
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Anonymous ,

use these measures:
 Productive Hours = CALCULATE(SUM('Employee Hours'[Hours]), FILTER(Table_name, Task <> "Task 3" ||  Task <> "Task 19" || Task <> "Task 44"))

 

Effective Base Hours =CALCULATE(SUM(Employee [Base Hours]), FILTER(Table_name, Task <> "Task 3" ||  Task <> "Task 19" || Task <> "Task 44"))

 

 

Utilization %= DIVIDE([Productive Hours],[Effective Base Hours])        .....format this to percentage.

 

 

I hope this helps!

 

Mark this as a solution if I answered your question. Kudos are always appreciated!

Thanks.