Forum Discussion

Thierry7890's avatar
Thierry7890
Frequent Visitor
4 years ago

Calculating productivity compared to target

Hello All,

 

I am quite new to Power BI and DAX and I have tried to find solutions online but I can't get it to work so I would greatly appreciate if someone could help me in the right direction.

 

I work in a multiclient warehouse and I'm trying to calculate productivity compared to a set target. 

[moves] / [hours] = productivity          40 / 2 = 20 moves per hour 

productivity / [target] = score              20 / 22 (set target) = 91% score

 

I have 2 tables. table 1 has the productivity data of the last year where the lines are on a user level and split per customer and process. and table 2 has the set target for each process also split by customer.

 

The result i'm trying to get is a weighed score on multiple levels, when i don't zoom in I want to be able to see a weighed score for the entire warehouse where each customer + activity is measured against the set target of that specific customer + target combination. we have the same activity for multiple customers but the targets can vary quite a lot. Also i want to be able to further filter on a customer lvl, a process level and a user level.

In the images below you can see the data I'm working with. I hope it's a bit clear.

 

thanks in advance