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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Cumulative measure for count

I have table that looks as follows:

 

Cumulative.PNG 

 

I have the month year and count. The cumulative is the measure that i would like to create. The value for jan 2018 is the same. Then Feb = count of Jan + Count of Feb. and March = count of Feb + Count of March and so on.

 

Any help? Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

This should work for your example

Cumulative Count = 
CALCULATE(
    SUM( 'Cumu Count Ex'[Count]),
    FILTER(
        ALL('Cumu Count Ex'[Date]),
        MAX('Cumu Count Ex'[Date]) >= 'Cumu Count Ex'[Date] 
    )
)

Cumulative Count.png

View solution in original post

1 REPLY 1
Anonymous
Not applicable

This should work for your example

Cumulative Count = 
CALCULATE(
    SUM( 'Cumu Count Ex'[Count]),
    FILTER(
        ALL('Cumu Count Ex'[Date]),
        MAX('Cumu Count Ex'[Date]) >= 'Cumu Count Ex'[Date] 
    )
)

Cumulative Count.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.