Forum Discussion
Solved
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 * On...
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.
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]
)