How can I perform an OR filter on a DirectQuery, based on a second table?

Hi Anonymous 

A calculated column on an import table can refer to other tables, but a calculated column on a DirectQuery table can still refer only to columns on the same table, but you can use a calculated table.

Maybe you can refer the follwing example.

Create a new table

Table 2 = SUMMARIZE(FILTER('Table',OR([Category]="Transportation",[Supplier] in VALUES('Table (2)'[Target Supplier]))),[Purchase ID],[Supplier],[Category],"IF",if([Category]="Transportation"&&[Supplier] in VALUES('Table (2)'[Target Supplier]),"Kept because target su and tra",IF([Category]="Transportation","Kept because  tra",IF([Supplier] in VALUES('Table (2)'[Target Supplier]),"Kept because target su "))))

You can refer to the following links about the limiations of direct query in composite mode

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#considerations-and-limitations

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#calculated-tables

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.