DAX IF Formula Statement Not Working

[Anonymous]

Hi,

Why is this formula not reflecting the 0.03 nor 0.05. Only 0.01 works. Any ideas?

Sales Commission = SUM('Facts Orders'[Sale]) * IF(SUM('Facts Orders'[Sale])<[SUM Goal 1 Meas],0.01,IF(SUM('Facts Orders'[Sale])>=[SUM Goal 1 Meas]&&SUM('Facts Orders'[Sale])<[SUM Goal 2 Meas],0.03,IF(SUM('Facts Orders'[Sale])>=[SUM Goal 2 Meas],0.05)))

This also does not work

Sales Commission = IF(SUM('Facts Orders'[Sale])<[SUM Goal 1 Meas],SUM('Facts Orders'[Sale])*0.01,IF(SUM('Facts Orders'[Sale])>=[SUM Goal 1 Meas]&&SUM('Facts Orders'[Sale])<[SUM Goal 2 Meas],SUM('Facts Orders'[Sale])*0.03,IF(SUM('Facts Orders'[Sale])>=[SUM Goal 2 Meas],SUM('Facts Orders'[Sale])*0.05)))

Thanks

[v-frfei-msft]

Hi @Anonymous,

Actually, in your formula, the result of the IF Statement is depending on the values of your measures. Here I made one sample that it applied to 0.03.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/pwvtusy0xdp7bem/DAX%20IF%20Formula%20Statement%20Not%20Working.pbix?dl=0

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank