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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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