cancel
Showing results for
Did you mean:

## Sales per employee adjusted by contract (%)

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 🐶

2 ACCEPTED SOLUTIONS
Super User I

would not

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

would this not work?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Resolver I
CALCULATE(
(SUM(EmpSales[Sales])/Sum(EmpContract[Employment contract (%)])*100
))
2 REPLIES 2
Resolver I
CALCULATE(
(SUM(EmpSales[Sales])/Sum(EmpContract[Employment contract (%)])*100
))
Super User I

would not

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

would this not work?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.