https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-CrossFilter-None/m-p/2464233#M66891 <P>Hi there,<BR /><BR />From my understanding I can use crossfilter + none to deactivate a relationship. Can I simply use this as an Calculate filter argument? Because just now I used crossfilter + none, as an argument and didnt work (perhaps because DAX was using first the Userelationship function), but then I wrapped the complete function around another calculate with crossfilter and it worked...</P> Tue, 19 Apr 2022 18:46:28 GMT campelliann 2022-04-19T18:46:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-CrossFilter-None/m-p/2464233#M66891 <P>Hi there,<BR /><BR />From my understanding I can use crossfilter + none to deactivate a relationship. Can I simply use this as an Calculate filter argument? Because just now I used crossfilter + none, as an argument and didnt work (perhaps because DAX was using first the Userelationship function), but then I wrapped the complete function around another calculate with crossfilter and it worked...</P> Tue, 19 Apr 2022 18:46:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-CrossFilter-None/m-p/2464233#M66891 campelliann 2022-04-19T18:46:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-CrossFilter-None/m-p/2464566#M66926 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="238661" data-lia-user-login="campelliann" class="lia-mention lia-mention-user">campelliann</a> , you need specify which table it should remove join and in case none it should do that.</P> <P>&nbsp;</P> <P>I have used the same in the active employee here in this blog</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970" target="_blank">https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970</A></P> Wed, 20 Apr 2022 01:52:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-CrossFilter-None/m-p/2464566#M66926 amitchandak 2022-04-20T01:52:32Z