Excel-source and DirectQuery - Table.FuzzyNestedJoin() equivalent

[TommyMossberg]

I have two table I would like to "FuzzyNestedJoin" but I don't know how to do that when one of them is a DirectQuery table. 
I've tried with create a new table with de DirictQuery-table as a source but I can't load it in PowerQuery to be able to use the way I'm used to.

I would like to be able to filter on FinancialActivityCodes that are only in DQ or only in Excel. When I create a relation today I get only those who appears in both.

Can anyone help me?

[amitchandak]

@TommyMossberg , Use that in a measure

calculate(sum(Table[Value]), filter(Table, Table[ID] in values(Excel[ID]) ) )

or create join and check for non blank in filter

calculate(sum(Table[Value]), filter(Table, not(isblank(Excel[ID]))  ) )