Help Calculate Bonus with % margin range

[rzilli]

Hi Guys

I need some help on this, I have the table below with the % margin achieved variance each 0.5% we pay a different bonus ( as the table below) 
paid monthly

I am trying to isert a formula to calculate by month, I tried If( didnt work)

[v-shex-msft]

Hi @rzilli,

Did Greg's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@rzilli Making some assumptions, seems like it should be something like:

Measure =
  VAR __Margin = 'Table'[Margin] //whatever you use to calculate your margin
RETURN
  MAXX(FILER('Margin Table',__Margin >= [Min %] && __Margin <= [Max %]),[Bonus Big Shop])