How to filter a Table USING IN Operator with the Values from another Table ?

[Anonymous]

Hi Team,

Good Day !

I'm trying to mimic this SQL script in dax powerbi 

SELECT * FROM TABLE1 WHERE TABLE1[ID] IN (SELECT TABLE2[ID] FROM TABLE2)

I'm trying to use filter and the IN operator however there is no prepared statement that I can use in Dax. Can you please help me achieve the same scenario. I prefer to do dax statement instead of doing it on the 'powerquery'

Thanks for your help in advance

Cheers!

[vapid128 · Accepted solution]

FILTER(TABLE1 , TABLE1[ID] in VALUES(TABLE2[ID]))

[Anonymous]

Thank you!!