Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
malpani
Helper I
Helper I

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 one rows out of two rows with ID 51921.

 

IDCountcFeatureNameApproval Age (days)
WTD Live-67801Feature 18
WTD Live-67861Feature 28
WTD Live-67821Feature 38
WTD Live-67891Feature 48
WTD Live-12331Feature 591
WTD Live-51921Feature 6224
WTD Live-51922Feature 6224

 

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.

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @malpani 
Please use

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

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @malpani 
Please use

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.