IF ISCROSSFILTERED performs better than IF HASONEVALUE

Written by Christian Wade on 08 January 2013. Posted in Tabular DAX

See this post for the functional difference between ISCROSSFILTERED and HASONEVALUE.

This DAX query on AdventureWorks runs in less than a second (SP1).