I have duplicate information in two columns but I need to add a single record

[Syndicate_Admin]

Hello.

If you can help me I have two columns "SPLITTER NAME" and "AMOUNT OF FREE PTS IN THE SPLITER", these records can be repeated in the rows, but I only need to add one record of the column "FREE PTS IN THE SPLITER".

From Girardota01 Just add 4, from Girardota02 just add 4, and so on.

[Anonymous]

Do you need to keep the duplicates because they also hold other information? 

If not, you can simply remove duplicates in the Query Editor

[Syndicate_Admin]

If I must keep duplicates.

[TomasAndersson]

Hi!

I'm not entirely sure what you're looking for. Do you want to create a new table, modify the table in your screenshot or do you want to calculate the sum of points as new measure, only counting the points from each splitter name once? 

[Syndicate_Admin]

I want to calculate the sum of points as a new measure.

To get a measure where Girardota01 4, Girardota02 4this would be equal to 8 although there are more records of both.

[TomasAndersson]

A SUMX() together DISTINCT() on the table should work then:

Sum Distinct = 
SUMX(DISTINCT(Table),Table[NOMBRE DE SPLITER])

I'm getting a result as below, with some own test data. This is how I've interpreted your desired result?

[Syndicate_Admin]

Hello, with what you tell me I get to add, but I add all the records and what I want is to add only one of each splitter name, I show you as follows in excel. Original Database:

The sum here gives me 77, in the next I show what I want him to give me. Database if it could be done manually to add by concatenating the duplicate fields:

21 is the sum I want to get.

[Syndicate_Admin]

Hello, with what you tell me I get to add, but I add all the records and what I want is to add only one of each splitter name, I show you as follows in excel. Original database: CITY AREA NODE NAME OF SPLITER NUMBER OF FREE PTS IN THE SPLITER SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-1 4 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-1 4 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-1 4 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-1 4 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-2 0 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-2 0 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-3 3 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-3 3 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-3 3 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-3 3 SOGAMOSO SOGAMOSO SPLITER CENTER 1-1-3 3 SOGAMOSO SOGAMOSO CENTER SOG SOG - 001 4 SOGAMOSO SOGAMOSO CENTER SOG SOG - 001 4 SOGAMOSO SOGAMOSO CENTER SOG SOG - 001 4 SOGAMOSO SOGAMOSO CENTER SOG SOG - 001 4 SOGAMOSO SOGAMOSO CENTER SOG - 002 5 CENTER SOGAMOSO SOGAMOSO SOG - 002 5 SOGAMOSO SOGAMOSO SOG CENTER - 002 5 SOGAMOSO SOGAMOSO SOG CENTER - 003 5 SOGAMOSO SOGAMOSO SOG CENTER - 003 5 SOGAMOSO SOGAMOSO SOG CENTER - 003 5 The sum here gives me 77, in the following I show what I want you to give me. Database if it could be done manual to add by concatenating the duplicate fields: CITY AREA NODE NAME OF SPLITER NUMBER OF FREE PTS IN THE SPLITER SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-1 4 SOGAMOSO SOGAMOSO CENTER SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SPLITER 1-1-2 0 SOGAMOSO SOGAMOSO CENTER SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO CENTER SOGAMOSO SOGAMOSO SPLITER 1-1-3 3 SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOG SOG - 001 4 SOGAMOSO SOGAMOSO CENTER SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOG SOG CENTER - 002 5 SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOG CENTER - 003 5 SOGAMOSO SOGAMOSO CENTER SOGAMOSO SOGAMOSO CENTER 21 21 is the sum I want to get.