Add duplicate values

[Syndicate_Admin]

I have a table with 2 columns

For example

Code Contract Sale

123 1000

123 1000

456 500

789 2000

789 2000

321 1000

What I need is a measure to add ONLY the unique values of each contract. That is, in these cases it would be to add

1000(by contract 123)+500(by contract 456)+2000(by contract789)+1000(by contract 321 )= 4,500

I'm very new to this. Thanks for the help!

[Anonymous · Accepted solution]

Hi @tonmagri ,

Here's my solution.

1.Create an index column group by the code  contract in the Power Query Editor.

2.Add a custom column to get the index, and expand the columns and remove the unneeded columns.

3.Create a measure to sum the unique value.

Total = CALCULATE(SUM('Table'[Sale]),FILTER(ALLSELECTED('Table'),[Index]=1))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.