Sum based on distinct values of another column

[sureshsonti]

Hi,
Requesting some help in creating a DAX formula. I have two columns (id and amount).
I have duplicate values in id column and as well as duplicate values in amount column.
I want to sum the amount column that has distinct values in id column.

I have attached a sample file with the desired result.

Thanks for all your help.

 

[sureshsonti]

Sorry to bother you guys, but can anyone take a shot at this problem.

Really appreciate all the help

 

[AlanSidman]

How about using Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Duplicates" = Table.Distinct(Source)
in
    #"Removed Duplicates"

 

[sureshsonti]

Thanks Alan. Will give it a try. Really appreciate your help.