Calculating with different multipliers based on value

[Drouden]

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-Value	Multiplier for values
10	0.015
100	0.025
1.000	0.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

[maruthisp · Accepted solution]

Hi Drouden,

As per your original post description I tried to implement a solution with DAX expression. Please check the below pbix file.
Calculating with different multipliers based on value.pbix

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[Drouden]

Thanks Maruthi, it worked out perfectly for me. The new context for the variable works like a charm. Have a great day,

Drou

[maruthisp]

Glad to hear, Drouden 🙂
Have a great day ahead!
Best regards,

Maruthi