Forum Discussion

jokkegian's avatar
jokkegian
Frequent Visitor
8 years ago
Solved

many to many relationship

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.
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

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

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
    jokkegian
    Frequent Visitor
    8 years ago

    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's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      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's avatar
        jokkegian
        Frequent Visitor
        8 years ago

        Phil_Seamark great!

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