Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX IF Formula Statement Not Working

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

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

     

    Regards,

    Frank

2 Replies