Forum Discussion

ajithsrc's avatar
ajithsrc
Regular Visitor
5 years ago
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( 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

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])) )

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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])) )