IF ISCROSSFILTERED performs better than IF HASONEVALUE

Written by Christian Wade on 08 January 2013.

User Rating: 5 / 5

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

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