Filter one column with another column in a different table

[ajithsrc]

Hi , Hope you are safe and healthy.

I need a help on below sceniors.

I have a list of cleints and owner name in one table ( Table A). I also have list of owners from UK in a different table( Table B). I want the entire report to reflect only the owners from UK.

So can i filter the owner from Table A with list in Table B using Dax? Or please suggest any alternative.

Thank you! Ajith

[amitchandak · Accepted solution]

@ajithsrc , one way is you can join them and filter using B.

Or you have to create measure/s like this

calculate(sum(TableA[Value]), filter(TableA, TableA[Owner] in values(TableB[Owner])) )