Forum Discussion

Drouden's avatar
Drouden
New Member
1 year ago
Solved

Calculating with different multipliers based on value

Hi,

 

I'm currently struggeling with a problem, which I cannot solve within Power BI. Based on definied quantities, we multiply within our controlling other values for some bonuses. 

This means:

 

Euro-ValueMultiplier for values
100.015
1000.025
1.0000.035

 

The complexity comes with the following rule. If we hit with our quantities 10.000, the following conditions needs to be applied:

If we hit 10.000€ for example, we need to calculate everything till 1.000 witht the multiplier 0.035, everything above needs to be calculated with 0.039 (1000*0.035+9000*0.039)=Final value

The first half of the problem I solve with this measure:

 

Outcomes_Multiplier =
VAR Multiplier = SWITCH(
TRUE,
[Euro-Values] < 10, 0.015,
[Euro-Values] >= 10 && [Invoiced Net Sales Including PM] < 100, 0.025,
[Euro-Values] >= 100 && [Invoiced Net Sales Including PM] < 1000, 0.035,
0
)
Var BonusEstimator = [Euro-Values] *(Multiplier)
RETURN
BonusEstimator

 

But I really can't find a solution for the last condition, where we combine two conditions.

Any help is greatly appreciated,

 

Drou

3 Replies