topic Re: Duplicate records with many to many relationships in DAX Commands and Tips

Duplicate records with many to many relationships

CarlSagan — Mon, 30 Dec 2024 18:10:36 GMT

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.

Re: Duplicate records with many to many relationships

Greg_Deckler — Mon, 30 Dec 2024 18:14:07 GMT

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.

Re: Duplicate records with many to many relationships

pcoley — Mon, 30 Dec 2024 19:17:06 GMT

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,.