How to solve relationship many to many ?

[Paulyeo11]

Hi All

When i add SEGMENT table to my PBI file , when i try to link segment field , i get :-

The linkage have multiple relationship.

My PBI file :-

https://www.dropbox.com/s/ealmerjjo8bfbpw/PB_TDS_V077%20USE%20THIS%20FOR%20ASK%20Q%20add%20segment%2...

Paul Yeo

[mohammedadnant · Accepted solution]

Hi @Paulyeo11 ,

Good day,

In order to avoid the manay-to-many relationship, you need to do the following steps

1. Extract unique values from 1 table - Treat this as a Master Table (Dimension table)

2. Add relationship with the table to fact table

3. Now you can use 1-Many relationship

Thanks & Regards,

Mohammed Adnan

www.youtube.com/taik18

[Paulyeo11]

Hi All

Thank you for sharing , but my issue is :-

[edhans]

You have to make it unique in one of the tables, and there can be no blanks or nulls in that field. Your segment_c field has a ton of blanks. You would have to:

• Right-click on that field in Power Query and tell it to remove duplicates
• Filter and on the dropdown menu, select "Remove Empty"

It can then be the 1 of a 1:Many relationship.