Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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.
Solved! Go to Solution.
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
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]
)