Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Productivity based on worked days

Hello,   I want to calculate monthly productivity of each employee based on orders processed vs expected orders.   I tried different DAXs but without succcess. I'd like to achieve below result as...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try measure like

    Expected Order = CALCULATE(sum(Orders[Orders]), ALLEXCEPT(Team,Team[Team]), ALLEXCEPT('Calendar', 'Calendar'[CalMonth_No])) * divide(SUM(Workdays[workdays]) , CALCULATE(SUM(Workdays[workdays]), ALLEXCEPT(Team,Team[Team]), ALLEXCEPT('Calendar', 'Calendar'[CalMonth_No])))

productivity % = DIVIDE(sum(Orders[Orders]),[Expected Order])

     

    file attached after signature

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try measure like

Expected Order = CALCULATE(sum(Orders[Orders]), ALLEXCEPT(Team,Team[Team]), ALLEXCEPT('Calendar', 'Calendar'[CalMonth_No])) * divide(SUM(Workdays[workdays]) , CALCULATE(SUM(Workdays[workdays]), ALLEXCEPT(Team,Team[Team]), ALLEXCEPT('Calendar', 'Calendar'[CalMonth_No])))

productivity % = DIVIDE(sum(Orders[Orders]),[Expected Order])

 

file attached after signature

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Wow! It was fast, your solution's working perfectly! Thanks! 🙂