Sum a column in a table based on unique IDs

[malpani]

Hello Experts, 

I have following data table. I have a requirement to calculate SUM of Approval Age (days) columns based on unique values in ID column. 

In table below, it should consider only one rows out of two rows with ID 51921.

ID	Count	cFeatureName	Approval Age (days)
WTD Live-6780	1	Feature 1	8
WTD Live-6786	1	Feature 2	8
WTD Live-6782	1	Feature 3	8
WTD Live-6789	1	Feature 4	8
WTD Live-1233	1	Feature 5	91
WTD Live-5192	1	Feature 6	224
WTD Live-5192	2	Feature 6	224

I tried referencing other threads but somehow it is not working and showing error with syntax. 

Sum DISTINCT = 

CALCULATE(SUM('WTD+SP_Pre-C3_Final'[Approval Age (days)]), FILTER('WTD+SP_Pre-C3_Final', DISTINCT('WTD+SP_Pre-C3_Final'[ID])))

Error Message - 

A table of multiple values was supplied where a single value was expected.

[tamerj1 · Accepted solution]

Hi @malpani 
Please use

Sum DISTINCT =
SUMX (
    VALUES ( 'WTD+SP_Pre-C3_Final'[ID] ),
    CALCULATE ( MAX ( 'WTD+SP_Pre-C3_Final'[Approval Age (days)] ) )
)