Forum Discussion
Can't use left anti join with DirectQuery
Hi 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.
I was afraid this would be the answer, since I am basing the entire report on "All Failures". The measure works to create it, but I'm not sure how to use it as a filter in the variety of visuals I'm creating based on the "All Failures" table. Thank you for responding though!
Hi ReadTheIron ,
Could you tell me if your issue has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your issue.
Best Regards,Rico Zhou
None of the proposed solutions helped; I ended up using Import instead of DirectQuery with a filtered table.
