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

emadrigal's avatar
emadrigal
Helper II
8 years ago

Have you tried creating a intermediate table for this relation., in table relation there is not a direct many to many relation., there always have to come a third table to haddle this relation.

 

try creating a table with those relation.