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 Jan + Count of Feb. and March = count of Feb + Count of March and so on.

 

Any help? Thanks!

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

1 Reply

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