topic Re: Second Filter criteria do not work in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Second-Filter-criteria-do-not-work/m-p/2595552#M74911 <DIV><SPAN>tblFilterData =&nbsp;</SPAN><SPAN>FILTER</SPAN><SPAN>(&nbsp;</SPAN></DIV><DIV><DIV class="lia-indent-padding-left-120px"><SPAN>CALCULATETABLE&nbsp;</SPAN><SPAN>(</SPAN><SPAN>Table_A</SPAN><SPAN>,&nbsp;</SPAN><SPAN>RELATEDTABLE</SPAN><SPAN>(</SPAN><SPAN>Table_B</SPAN><SPAN>)</SPAN><SPAN>),</SPAN></DIV><DIV class="lia-indent-padding-left-120px"><SPAN>AND (</SPAN><SPAN>not</SPAN><SPAN>&nbsp;(</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"ABC"</SPAN><SPAN>)) ,</SPAN></DIV><DIV class="lia-indent-padding-left-120px"><SPAN>not</SPAN><SPAN>&nbsp;(</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"XYZ")&nbsp;</SPAN><SPAN>))</SPAN></DIV><DIV class="lia-indent-padding-left-150px"><SPAN>)<BR /></SPAN></DIV></DIV> Wed, 22 Jun 2022 16:11:05 GMT atiftanveer 2022-06-22T16:11:05Z Second Filter criteria do not work https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Second-Filter-criteria-do-not-work/m-p/2595141#M74886 <DIV><DIV><SPAN>Hi,</SPAN></DIV><DIV>&nbsp;</DIV><DIV>following DAX expression do not filter rows match second critatia i.e. <SPAN>Table_A[Email] not ContainString "XYZ". I can see rows conting XYZ in table. What's worng!</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>tblFilterData = </SPAN><SPAN>FILTER</SPAN><SPAN>(&nbsp;</SPAN></DIV><DIV class="lia-indent-padding-left-120px"><SPAN>CALCULATETABLE&nbsp; &nbsp;&nbsp;</SPAN><SPAN>(&nbsp;</SPAN><SPAN>Table_A</SPAN><SPAN>,&nbsp;</SPAN><SPAN>RELATEDTABLE</SPAN><SPAN>(</SPAN><SPAN>Table_B</SPAN><SPAN>)</SPAN></DIV><DIV class="lia-indent-padding-left-270px"><SPAN>), </SPAN><SPAN>not</SPAN><SPAN> (</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"ABC"</SPAN><SPAN>) &amp;&amp; </SPAN></DIV><DIV class="lia-indent-padding-left-300px"><SPAN>not</SPAN><SPAN> (</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"XYZ"</SPAN><SPAN>))</SPAN></DIV><DIV class="lia-indent-padding-left-150px"><SPAN>)</SPAN></DIV><DIV class="lia-indent-padding-left-150px">&nbsp;</DIV><DIV><SPAN>Regards</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Atif</SPAN></DIV></DIV> Wed, 22 Jun 2022 13:41:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Second-Filter-criteria-do-not-work/m-p/2595141#M74886 atiftanveer 2022-06-22T13:41:54Z Re: Second Filter criteria do not work https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Second-Filter-criteria-do-not-work/m-p/2595552#M74911 <DIV><SPAN>tblFilterData =&nbsp;</SPAN><SPAN>FILTER</SPAN><SPAN>(&nbsp;</SPAN></DIV><DIV><DIV class="lia-indent-padding-left-120px"><SPAN>CALCULATETABLE&nbsp;</SPAN><SPAN>(</SPAN><SPAN>Table_A</SPAN><SPAN>,&nbsp;</SPAN><SPAN>RELATEDTABLE</SPAN><SPAN>(</SPAN><SPAN>Table_B</SPAN><SPAN>)</SPAN><SPAN>),</SPAN></DIV><DIV class="lia-indent-padding-left-120px"><SPAN>AND (</SPAN><SPAN>not</SPAN><SPAN>&nbsp;(</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"ABC"</SPAN><SPAN>)) ,</SPAN></DIV><DIV class="lia-indent-padding-left-120px"><SPAN>not</SPAN><SPAN>&nbsp;(</SPAN><SPAN>CONTAINSSTRING</SPAN><SPAN>(</SPAN><SPAN>Table_A[Email]</SPAN><SPAN>,</SPAN><SPAN>"XYZ")&nbsp;</SPAN><SPAN>))</SPAN></DIV><DIV class="lia-indent-padding-left-150px"><SPAN>)<BR /></SPAN></DIV></DIV> Wed, 22 Jun 2022 16:11:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Second-Filter-criteria-do-not-work/m-p/2595552#M74911 atiftanveer 2022-06-22T16:11:05Z