Sum a column in a table based on unique IDs

malpani — Mon, 08 Aug 2022 06:31:52 GMT

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.

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.

Re: Sum a column in a table based on unique IDs

tamerj1 — Mon, 08 Aug 2022 06:56:25 GMT

Hi malpani
Please use

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