Forum Discussion
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-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
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.pbixIf 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
3 Replies
- maruthispSuper User
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.pbixIf 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