Duplicate records with many to many relationships

[CarlSagan]

Hi All,

I have a schema that has a many to many relationship where the join is causing the table to produce duplicate aggregation records. I've tried creating a "bridge" table, which is actually just the concatenation of two columns in each of the tables joining with each other.  I am joining on two columns; planid and account number and when these are the same it results in duplicate records

Another example,

I know this has to do with the data model but I've tried so many of the normal solutions and nothing seems to be working to achieve the goal of having the records correctly partition (group) based on planid AND account number.

[pcoley]

@CarlSagan 
can you share more about your model?

so we can see the tables and relationship, tring to find ambiguity or measure adjustemnt that can not be donne just with the name of the columns,.

[Greg_Deckler]

@CarlSagan In Power Query, select all of the columns in your table, right-click, and choose Remove Duplicates. You could also use DISTINCT against the whole table in DAX to remove any duplicate rows.