DAX IF Formula Statement Not Working

Question

Hi,&nbsp;Why is this formula not reflecting the 0.03 nor 0.05. Only 0.01 works. Any ideas?&nbsp;&nbsp;Sales Commission = SUM('Facts Orders'[Sale]) * IF(SUM('Facts Orders'[Sale])&lt;[SUM Goal 1 Meas],0.01,IF(SUM('Facts Orders'[Sale])&gt;=[SUM Goal 1 Meas]&amp;&amp;SUM('Facts Orders'[Sale])&lt;[SUM Goal 2 Meas],0.03,IF(SUM('Facts Orders'[Sale])&gt;=[SUM Goal 2 Meas],0.05)))&nbsp;This also does not work&nbsp;Sales Commission = IF(SUM('Facts Orders'[Sale])&lt;[SUM Goal 1 Meas],SUM('Facts Orders'[Sale])*0.01,IF(SUM('Facts Orders'[Sale])&gt;=[SUM Goal 1 Meas]&amp;&amp;SUM('Facts Orders'[Sale])&lt;[SUM Goal 2 Meas],SUM('Facts Orders'[Sale])*0.03,IF(SUM('Facts Orders'[Sale])&gt;=[SUM Goal 2 Meas],SUM('Facts Orders'[Sale])*0.05)))&nbsp;Thanks

v-frfei-msft · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
Does that make sense? If so, kindly mark my answer as a solution to close the case.
&nbsp;
Regards,
Frank

Forum Discussion

Related content

If formula

DAX Formula Help

formula

DAX Formula IF Statement Dates

Lookup formula not working