Calculating productivity compared to target

[Thierry7890]

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

[amitchandak]

@Thierry7890 , Have you already created common tables like customer and activity? Using those you can analyze data together

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...