Add duplicate values

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.