topic Calculating with different multipliers based on value in DAX Commands and Tips

Calculating with different multipliers based on value

Drouden — Sun, 15 Jun 2025 09:34:31 GMT

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

Re: Calculating with different multipliers based on value

maruthisp — Sun, 15 Jun 2025 10:57:17 GMT

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

Re: Calculating with different multipliers based on value

Drouden — Sun, 15 Jun 2025 11:29:24 GMT

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

Drou

Re: Calculating with different multipliers based on value

maruthisp — Sun, 15 Jun 2025 11:47:27 GMT

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

Maruthi