Forum Discussion

attempt1's avatar
attempt1
Frequent Visitor
1 year ago
Solved

Issue with Cumulative Sum Measure

Hello,   My measure to calculate the cumulative sum of rows (excluding rows where the 'End' column date has past) is not working as intended in my stacked column chart when no slicer filter is sele...
Need Help
  • hnguy71's avatar
    hnguy71
    1 year ago

    Hi attempt1 ,

    try this:

     

     

    all_data_cumulative = 

VAR _CurrDate = MAX('date_table'[Date])

RETURN

CALCULATE(
    COUNTROWS('all_data'),
    KEEPFILTERS(
        'all_data'[Start] <= _CurrDate &&
        'all_data'[End] > _CurrDate
    ),
    ALLSELECTED(date_table)
)

     

    This may be your expected output:

     

     

hnguy71's avatar
hnguy71
Super User
1 year ago

Hi attempt1 ,

try this:

 

 

all_data_cumulative = 

VAR _CurrDate = MAX('date_table'[Date])

RETURN

CALCULATE(
    COUNTROWS('all_data'),
    KEEPFILTERS(
        'all_data'[Start] <= _CurrDate &&
        'all_data'[End] > _CurrDate
    ),
    ALLSELECTED(date_table)
)

 

This may be your expected output:

 

 

  • attempt1's avatar
    attempt1
    Frequent Visitor
    1 year ago

    Yes, thank you so much hnguy71 , exactly what I wanted.