calculate dynamic multiplication

[nidhs909]

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. 

BonusAmt = if(Merged[Tier] == "TIER1" && Merged[OffOn] == "ONSHORE",LOOKUPVALUE(BonusRates[Tier1On],BonusRates[Grade],Merged[Employees.Grade]),

        if(Merged[Tier] == "TIER1" && Merged[OffOn] == "OFFSHORE",LOOKUPVALUE(BonusRates[Tier1Off],BonusRates[Grade],Merged[Employees.Grade]),

        if(Merged[Tier] == "TIER2" && Merged[OffOn] == "OFFSHORE",LOOKUPVALUE(BonusRates[Tier2Off],BonusRates[Grade],Merged[Employees.Grade]),

        if(Merged[Tier] == "TIER2" && Merged[OffOn] == "ONSHORE",LOOKUPVALUE(BonusRates[Tier2On],BonusRates[Grade],Merged[Employees.Grade])

))))

[Anonymous · Accepted 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.

[Bibiano_Geraldo]

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]
)