Forum Discussion
Solved
Filter one column with another column in a different table
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( ...
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])) )
amitchandak
Super User
Super Userajithsrc , 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])) )