Forum Discussion

kapil512's avatar
kapil512
Helper 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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft 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
Helper 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
    Microsoft 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
      Helper II
      8 years ago

      Thank you Yulgu,

       

      Its working fine.

       

      Thanks,

      Kapil Dev