Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative measure for count

I have table that looks as follows:       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 J...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    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] 
    )
)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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] 
    )
)