Many to Many relationship for below data.

[kapil512]

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
00124000005BmAAI	MSL			00524000001goTCAAY	MSL
00124000005BvAAI	MSL			00524000001goTCAAY	MSL
00124000006BxAAI	MSL
00124000007AmAAI	MSL

for above data, TERR_Nameis the column data and that is M:M R/S.

For that i have created the Distinct values and created the Bridge table, but when i drag the both tables feilds to single report its saying R/S does not exit.

Can anyone please help me out,how to do this?

Thanks,

Kapil

[emadrigal]

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.

[parry2k]

What you mean by R/S doesn't exists?

How your bridge table look like? How you are setting up the relationship?

[kapil512]

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]

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]

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 · Accepted solution]

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]

Thank you Yulgu,

Its working fine.

Thanks,

Kapil Dev