Forum Discussion

malpani's avatar
malpani
Icon for Helper II rankHelper II
4 years ago
Solved

Sum a column in a table based on unique IDs

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 on...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi malpani 
    Please use

    Sum DISTINCT =
SUMX (
    VALUES ( 'WTD+SP_Pre-C3_Final'[ID] ),
    CALCULATE ( MAX ( 'WTD+SP_Pre-C3_Final'[Approval Age (days)] ) )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi malpani 
Please use

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