many to many relationship

[jokkegian]

does someone know a solution for this many to many relationship?

Every column in the 2 tabels is many to many.

I find no solution for this. I will also filter these 2 tabels together.

[Phil_Seamark]

Hi @jokkegian

Create a separate table with every unique possible Type.  And link the two existing tables to it and use the new table in slicers (will filter both tables on the many side).

Repeat for other columns as necessary.

[jokkegian]

Hi @Phil_Seamark 

Thank you for your answer, it works.

But now if i filter first on country and then on regions then i see all the regions in the table (not only the regions from the selected country)

How can i fix this?

[Phil_Seamark]

Why not combine the Country and Region into a single table with two columns.

I assume every region belongs to a country.

Make sure the regions in your new lookup table is unqiue and create a relationship between Region and your other tables.  Then you can slicer on country, or region in your new table and it will make more sense.

[jokkegian]

@Phil_Seamark great!

Now i will also filter on company and a company occurs serveral times in a region and country

[Phil_Seamark · Accepted solution]

It might pay to keep company as a separate lookup table as you may have companies that can appear in multiple regions/countries.