topic IF condition with AND statement desn't work in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961768#M11254 <P>Hello,</P><P>&nbsp;</P><P>As you can see in the image, I think normaly we will need to have "1" as value when A = 2 and A = 4.</P><P>&nbsp;</P><P>Do you have any idea why I got "0" even if the condition is true ?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you</P> Fri, 06 Mar 2020 08:40:36 GMT Anonymous 2020-03-06T08:40:36Z IF condition with AND statement desn't work https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961768#M11254 <P>Hello,</P><P>&nbsp;</P><P>As you can see in the image, I think normaly we will need to have "1" as value when A = 2 and A = 4.</P><P>&nbsp;</P><P>Do you have any idea why I got "0" even if the condition is true ?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you</P> Fri, 06 Mar 2020 08:40:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961768#M11254 Anonymous 2020-03-06T08:40:36Z Re: IF condition with AND statement desn't work https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961814#M11255 <P>Anonymous</LI-USER>&nbsp;</P> <P>yuot statement says that Sheet1[A] has to be equal to 2 and 4 at the same time. It looks impossible <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>Maybe you need OR logic, for that use || symbol, not &amp;&amp; (AND)</P> Fri, 06 Mar 2020 09:01:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961814#M11255 az38 2020-03-06T09:01:12Z Re: IF condition with AND statement desn't work https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961876#M11258 <P>Okay thank you <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="82403" data-lia-user-login="az38" class="lia-mention lia-mention-user">az38</a> for your answer.</P> Fri, 06 Mar 2020 09:28:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-condition-with-AND-statement-desn-t-work/m-p/961876#M11258 Anonymous 2020-03-06T09:28:55Z