Using CrossFilter + None

[campelliann]

Hi there,

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...

[amitchandak]

@campelliann , you need specify which table it should remove join and in case none it should do that.

I have used the same in the active employee here in this blog

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...