Forum Discussion
calculate dynamic multiplication
Hello,
This is my table and what i would like to achieve is,
If Threshold >= 3, calculate (BonusAmt * OnshoreCount * OnshoreCount * 1.15)
else (BonusAmt * OnshoreCount * OnshoreCount)
Note that Bonus Amount itself is a measure and below is the formula.
Hi, nidhs909
I've simply modeled your data, please check to see if it matches your situation.
If this does not solve your problem, please provide more example data.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi nidhs909 ,
You can achieve your goal using this DAX measure:
FinalBonus = IF( Merged[Threshold] >= 3, [BonusAmt] * Merged[OnshoreCount] * Merged[OnshoreCount] * 1.15, [BonusAmt] * Merged[OnshoreCount] * Merged[OnshoreCount] )Hi, nidhs909
I've simply modeled your data, please check to see if it matches your situation.
If this does not solve your problem, please provide more example data.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
