topic DAX Crossfilter in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2870118#M92583 <P>Hey, could you help with new function that i m using, crossfilter.&nbsp; Red text is a part of original formula, black is an addition with crossfilter. My model works with bi directional relation.</P><P><img /></P><P>&nbsp;</P><DIV><DIV><SPAN>crossfilter tscan = </SPAN></DIV><DIV><FONT color="#FF0000"><SPAN>VAR</SPAN> <SPAN>Test</SPAN><SPAN> =</SPAN></FONT></DIV><DIV><FONT color="#FF0000"><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN> ( </SPAN><SPAN>TJob</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[SekundærNavn]</SPAN><SPAN> = </SPAN><SPAN>"Testing"</SPAN><SPAN>)</SPAN></FONT></DIV><DIV><FONT color="#FF0000"><SPAN>RETURN</SPAN></FONT></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><FONT color="#FF0000"><SPAN>( </SPAN><SPAN>DIVIDE</SPAN><SPAN> ( </SPAN><SPAN>SUMX</SPAN><SPAN> ( </SPAN><SPAN>Test</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[FirstPassQty]</SPAN><SPAN> ), </SPAN><SPAN>SUMX</SPAN><SPAN> ( </SPAN><SPAN>Test</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[Antal]</SPAN></FONT><SPAN><FONT color="#FF0000"> ) )</FONT>,</SPAN><SPAN>CROSSFILTER</SPAN><SPAN>(</SPAN><SPAN>TJob</SPAN><SPAN>[ID]</SPAN><SPAN>,</SPAN><SPAN>TScan</SPAN><SPAN>[RefID]</SPAN><SPAN>, </SPAN><SPAN>Both</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>Tscan has name filter that i want to apply on chart</P><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV></DIV> Fri, 28 Oct 2022 08:53:33 GMT Anonymous 2022-10-28T08:53:33Z DAX Crossfilter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2870118#M92583 <P>Hey, could you help with new function that i m using, crossfilter.&nbsp; Red text is a part of original formula, black is an addition with crossfilter. My model works with bi directional relation.</P><P><img /></P><P>&nbsp;</P><DIV><DIV><SPAN>crossfilter tscan = </SPAN></DIV><DIV><FONT color="#FF0000"><SPAN>VAR</SPAN> <SPAN>Test</SPAN><SPAN> =</SPAN></FONT></DIV><DIV><FONT color="#FF0000"><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN> ( </SPAN><SPAN>TJob</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[SekundærNavn]</SPAN><SPAN> = </SPAN><SPAN>"Testing"</SPAN><SPAN>)</SPAN></FONT></DIV><DIV><FONT color="#FF0000"><SPAN>RETURN</SPAN></FONT></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><FONT color="#FF0000"><SPAN>( </SPAN><SPAN>DIVIDE</SPAN><SPAN> ( </SPAN><SPAN>SUMX</SPAN><SPAN> ( </SPAN><SPAN>Test</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[FirstPassQty]</SPAN><SPAN> ), </SPAN><SPAN>SUMX</SPAN><SPAN> ( </SPAN><SPAN>Test</SPAN><SPAN>, </SPAN><SPAN>TJob</SPAN><SPAN>[Antal]</SPAN></FONT><SPAN><FONT color="#FF0000"> ) )</FONT>,</SPAN><SPAN>CROSSFILTER</SPAN><SPAN>(</SPAN><SPAN>TJob</SPAN><SPAN>[ID]</SPAN><SPAN>,</SPAN><SPAN>TScan</SPAN><SPAN>[RefID]</SPAN><SPAN>, </SPAN><SPAN>Both</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>Tscan has name filter that i want to apply on chart</P><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV></DIV> Fri, 28 Oct 2022 08:53:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2870118#M92583 Anonymous 2022-10-28T08:53:33Z Re: DAX Crossfilter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2872493#M92751 <P>ref</P> Sat, 29 Oct 2022 21:01:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2872493#M92751 Anonymous 2022-10-29T21:01:51Z Re: DAX Crossfilter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2874259#M92844 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>Please share some sample data so that we could test the formula.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jay</P> Mon, 31 Oct 2022 09:15:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2874259#M92844 Anonymous 2022-10-31T09:15:42Z Re: DAX Crossfilter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2874375#M92854 <P><A href="https://drive.google.com/file/d/1j1mmGwl4hEeruCdLLvvcOPOsO6R6FlHr/view?usp=sharing" target="_blank">https://drive.google.com/file/d/1j1mmGwl4hEeruCdLLvvcOPOsO6R6FlHr/view?usp=sharing</A></P> Mon, 31 Oct 2022 09:55:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2874375#M92854 Anonymous 2022-10-31T09:55:56Z Re: DAX Crossfilter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2895226#M94081 <P>ref</P> Wed, 09 Nov 2022 11:50:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Crossfilter/m-p/2895226#M94081 Anonymous 2022-11-09T11:50:27Z