Forum Discussion

kapil512's avatar
kapil512
Icon for Helper II rankHelper II
8 years ago
Solved

Many to Many relationship for below data.

Hi,   Can any one please help meto solve the below Issue.   I am trying to create the relationship for the below data, this is for M:M.   AccountID TERR_NAME   USER_ID TERR_NAME 00124...
Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi kapil512,

     

    I don't think it make sense to get the cloumns from both tables for Many to Many releationship tables data into single Visual. Take below two tables as an example, for record "B 4" in Table1, which value in Table2[Column4] should be matched with it? How to dispaly all these columns in visual?

     

    Or if you want to dispaly values in visual like below, you could create a calculated table via crossjoin two tables then filter.

    DAX similar to:

    Table4 =
FILTER ( CROSSJOIN ( Table1, Table2 ), Table1[Column1] = Table2[Column3] )

     

    A 1 gdh
    A 2 gdh
    A 3 gdh
    B 4 sthsrtj
    B 4 sga
    B 4 hh
    B 4 dh
    B 56 sthsrtj
    B 56 sga
    B 56 hh
    B 56 dh

     

    By the way, do mask sensitive data before uploading detailed data.

     

    Regards,
    Yuliana Gu

kapil512's avatar
kapil512
Icon for Helper II rankHelper II
8 years ago

Hi Parry,

 

Thank you for your response..!

 

R/S means relationship.

 

my bridge table is like this. 

 

 
Bridge Table Column
MSL
MSL Admin
MSL Lead

 

Thanks,

Kapil

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi kapil512,

 

It is not allowed to add fields from Many to Many tables into a single visual. As the error prompts, it cannot determine which row is uniquely matched with in another table.

 

Best regards,
Yuliana Gu

  • kapil512's avatar
    kapil512
    Icon for Helper II rankHelper II
    8 years ago

    Thank you for your response..!

     

    Do we have any other solution to get the cloumns from both tables for Many to Many releationship tables data into single Visual.

     

    Thanks,

    Kapil

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi kapil512,

       

      I don't think it make sense to get the cloumns from both tables for Many to Many releationship tables data into single Visual. Take below two tables as an example, for record "B 4" in Table1, which value in Table2[Column4] should be matched with it? How to dispaly all these columns in visual?

       

      Or if you want to dispaly values in visual like below, you could create a calculated table via crossjoin two tables then filter.

      DAX similar to:

      Table4 =
FILTER ( CROSSJOIN ( Table1, Table2 ), Table1[Column1] = Table2[Column3] )

       

      A 1 gdh
      A 2 gdh
      A 3 gdh
      B 4 sthsrtj
      B 4 sga
      B 4 hh
      B 4 dh
      B 56 sthsrtj
      B 56 sga
      B 56 hh
      B 56 dh

       

      By the way, do mask sensitive data before uploading detailed data.

       

      Regards,
      Yuliana Gu

      • kapil512's avatar
        kapil512
        Icon for Helper II rankHelper II
        8 years ago

        Thank you Yulgu,

         

        Its working fine.

         

        Thanks,

        Kapil Dev