Forum Discussion
ReadTheIron
Helper III
Helper IIICan't use left anti join with DirectQuery
I have a very large table ("All Failures") I'm connected to with DirectQuery. I'm trying to filter these records so as to exclude the ones that appear on a much smaller list ("Disqualified Failures")...
rajendraongole1
Super User
Super UserHi ReadTheIron -, you'll need to approach the problem using a method that avoids complex transformations like merges, which are unsupported in DirectQuery.
create a measure as below
ExcludedFailures =
IF(
COUNTROWS(
FILTER('Disqualified Failures',
'Disqualified Failures'[FailureID] = MAX('All Failures'[FailureID])
)
) > 0,
BLANK(),
1
)
Hope this helps.