Bonus Calculation

[rzilli]

Hi All

I need some help with a  Bonus calculation for my company

Our sales Team will get an extra bonus when they achieve a target, the bonus is progressive.

If they achieve lets say 1.2M to 1.4M and the margin 13% they will get a bonus related to the 200k they made that should be calculated by the 200k * for the margin that they made.

then we will have 1.4m to 1.6m same situation  and so on.

The bonus is linked if they achieve the % margin and the value

Can someone help me on this?? thanks 

[Anonymous · Accepted solution]

Hi @rzilli ,

If you have a table contians margin and bonus rate, you could use switch function to create measure.

https://docs.microsoft.com/en-us/dax/switch-function-dax .

If you want detailed formula, please share some sample data and expected result.

Best Regards,

Jay