Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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!

1 ACCEPTED SOLUTION
vapid128
Solution Specialist
Solution Specialist

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

View solution in original post

2 REPLIES 2
vapid128
Solution Specialist
Solution Specialist

FILTER(TABLE1 , TABLE1[ID] in VALUES(TABLE2[ID]))
Anonymous
Not applicable

Thank you!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.