Productivity based on worked days

[JarekkWr]

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 I had it in excel before:

I prepared pbix with sample data so it would be easier for you to catch my thinking (LINK):

I'd appreciate any help!

Thanks and br,

Jarek

[amitchandak · Accepted solution]

@JarekkWr , 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

[JarekkWr]

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

[amitchandak]

@JarekkWr , Can you share expected output. I checked the file. Not very clear what is missing or expected.

[JarekkWr]

@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