how to filter a table visual by a column from another table?

[ADI1212]

hi all!

i have 2 tables:

 company table that  looks like this:

and locations around the work of said comapnies table:

they have a one to many relationship

now i was asked to make comapny table as a table visual and the location from locations table as a filter like this: 

but!! the filter is not working and the table isnt being filtered by the location 😞

adding the location filter as a filed to the table visual makes duplicates and i cant have that

is there a way to make this filter work?

all help is much appreciated !

[ADI1212]

yes a one to many relationship through company name

[Idrissshatila]

@ADI1212 , the relationship arrow i going towards which table ?

[Idrissshatila]

Hello,

In the data Model, is there a relationship between these two tables, because in order to filter from one table to another there should be a relationship between the two.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡