Sales per employee adjusted by contract (%)

[qwertzuiop]

Hello dear Power BI-Community

Let's asume these two tables:

Employee ID	Sales
11	45
12	65
13	24
14	78
15	45
16	35
17	21
18	69
19	78
20	12
...

Employee ID	Employment contract (%)
11	50
12	100
13	20
14	100
15	50
16	40
17	20
18	50
19	90
20	20
...

What i would like to calculate is the following column in red:

The column is calculated by assuming that all employees work full time (Sales / Contract% * 100)

Employee ID	Sales	Sales adjusted
11	45	90.0
12	65	65.0
13	24	120.0
14	78	78.0
15	45	90.0
16	35	87.5
17	21	105.0
18	69	138.0
19	78	86.7
20	12	60.0
...

Thank you very much for your contribution.

Cheers

qwertzuiop 🐶

[vanessafvg · Accepted solution]

would not 

measurename = calculate(divide(sum(sales), sum(employmentcontract)) * 100

would this not work?

[pradeept · Accepted solution]

Sales adjusted =

CALCULATE(

(SUM(EmpSales[Sales])/Sum(EmpContract[Employment contract (%)])*100

))

[vanessafvg · Accepted solution]

would not 

measurename = calculate(divide(sum(sales), sum(employmentcontract)) * 100

would this not work?