Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
What you mean by R/S doesn't exists?
How your bridge table look like? How you are setting up the relationship?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
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
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
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
Thank you Yulgu,
Its working fine.
Thanks,
Kapil Dev
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |