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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
zaza
Resolver III
Resolver III

Cumulative Sum of a column for only the Distinct values of another column

I have the following cummulative count measure whihc works fine:

Count = 
    CALCULATE ( 
        DISTINCTCOUNT ( 'X Data'[Story ID] ), 
        FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ), 
        USERELATIONSHIP ( 'Date'[Date], 'X Data'[_Story-Sprint Start] ) 
    )

However I would like to SUM another column but only for the distinct values (so basically ignoring duplicate rows)

SUM = 
    CALCULATE ( 
        SUM ( 'X Data'[Story Pints] ), `<-But only for the Distinct of Story ID` 
        FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ), 
        USERELATIONSHIP ( 'Date'[Date], 'X Data'[_Story-Sprint Start] ) 
    )

 

1 REPLY 1
amitchandak
Super User
Super User

@zaza , Try like

 

SUM =
CALCULATE (
SUMX( Summarize('X Data','X Data'[Story ID] , 'X Data'[Story Pints]), [Story Pints] ), // `<-But only for the Distinct of Story ID`
FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ),
USERELATIONSHIP ( 'Date'[Date], 'X Data'[_Story-Sprint Start] )
)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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