Forum Discussion
Productivity based on worked days
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 , Can you share expected output. I checked the file. Not very clear what is missing or expected.
amitchandak , thanks for respons!
I'd like to see what is productivity of each employee by taking into consideration total number of orders entered by an employee vs expected number of total orders for an employee. For example:
Team A (John and Alice) entered 100 orders in one month. John entered 60 orders (worked 20 days) and Alice entered 40 orders (worked 15 days). In total they worked 35 days (John 57,14% and Alice 42,86%). As there were 100 orders in total for whole team it means that for John it was expected to process 57 orders during that month and for Alice it was 43 orders. However John processed 60 orders so his productivity was 105% and Alice processed 40 orders so her productivity was 93,33%. In excel it would look like that:
Expected number of orders is calculated by % of Team Workforce X Total orders and Productivity is calculated by # Orders / Expected #Orders.
Unfortunately I don't know how to translate it into DAX.
I hope it's clearer now.
BR,
Jarek