https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-VARIABLE-filter-from-another-Variable/m-p/3286985#M122230 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="206697" data-lia-user-login="Kerensky34" class="lia-mention lia-mention-user">Kerensky34</a>&nbsp;,</P> <P>Please have a try.</P> <P>Try to use filter.</P> <P><img /></P> <P>The measure is 0 or is not 0.</P> <P>&nbsp;</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly</A>&nbsp;</P> <P>&nbsp;</P> <P>If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .</P> <P>&nbsp;</P> <P>Best Regards<BR />Community Support Team _ Rongtie</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 16 Jun 2023 01:55:47 GMT Anonymous 2023-06-16T01:55:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-VARIABLE-filter-from-another-Variable/m-p/3284521#M122083 <P>I&nbsp; have a varible, that I am trying to return ONLY shipments from SHIPMENT ID&nbsp;</P><P>&nbsp;</P><P><SPAN>VAR</SPAN><SPAN>&nbsp;shippingdays</SPAN><SPAN>&nbsp;=</SPAN></P><DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Average transitDays]</SPAN><SPAN>, </SPAN><SPAN>'shipment'[ship_INDR]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>"Y"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN> ( </SPAN><SPAN>AvgshipedNonDDA</SPAN><SPAN> = </SPAN><SPAN>BLANK</SPAN><SPAN> (), </SPAN><SPAN>0</SPAN><SPAN>, AvgshipedNonDDA</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P><P>&nbsp;</P><P>How do I filter out the data that dont belong to get this result?</P><P>&nbsp;</P><img /><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P></DIV></DIV> Wed, 14 Jun 2023 20:49:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-VARIABLE-filter-from-another-Variable/m-p/3284521#M122083 Kerensky34 2023-06-14T20:49:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-VARIABLE-filter-from-another-Variable/m-p/3286985#M122230 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="206697" data-lia-user-login="Kerensky34" class="lia-mention lia-mention-user">Kerensky34</a>&nbsp;,</P> <P>Please have a try.</P> <P>Try to use filter.</P> <P><img /></P> <P>The measure is 0 or is not 0.</P> <P>&nbsp;</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly</A>&nbsp;</P> <P>&nbsp;</P> <P>If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .</P> <P>&nbsp;</P> <P>Best Regards<BR />Community Support Team _ Rongtie</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 16 Jun 2023 01:55:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-VARIABLE-filter-from-another-Variable/m-p/3286985#M122230 Anonymous 2023-06-16T01:55:47Z