Forum Discussion
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(...
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank