Filtering DirectQuery table based on import mode table

[MicrosoftPBI]

Hi!
I have two tables:
Table A (directquery from cloud dataset), contains most KPI-s and value X
Table B (import mode SQL query), contains value X

I need to show all Table A data except rows where value X is also in table B. So in other words I need to show all table A data except where value X in table A matches with value X in table B. 
I have the solution using DAX table, but since I am working with directquery dataset, the DAX table causes this error when refreshing the report in PBI cloud:

•          "Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references             Analysis Services using DirectQuery."
  

How can I filter table (based on Directquery) to exclude rows which have matching values in column X while keeping cloud refresh functionality?

Thanks

[MicrosoftPBI]

Thank you very much.
Instead of having to create a DAX table, I was able to use this DAX measure and use it on the table level as filter. The PBI cloud refresh works, thanks!

[newbeeToPBI]

Can you provide the solution here so others can benefit from this

[amitchandak · Accepted solution]

@MicrosoftPBI , You can create a measure like this and use in visual or visual level filter

assume ID column is key in both 

Countrows(filter(TableA, not TableA[ID] in values(TableB[ID]) ) )

[leathard]

What a helpful post.  Thank you.  I was struggling to filter a Direct Query reusable date dimension table by the date range in a transaction table.  The date table has too many pivotal attribute columns to recreate in DAX, all organized into folders.  This technique is also useful for limiting slicers on the Direct Query table based on the transaction date range in an import table. 

[ipoole]

When using this filter, set the filter to Greater than Zero, or something else?

Thanks for your help.