What's wrong with my Cumulative code?

[paulcar]

Count of Active Clients =

CALCULATE(

COUNTROWS('EDITOR CLIENT DATA'),

FILTER('EDITOR CLIENT DATA','EDITOR CLIENT DATA'[C STATUS]="ACTIVE"),

FILTER(

ALLSELECTED( 'Date'),

'Date'[Date] <= MAX( 'Date'[Date])))

It doesn't reflect the correct cumulative values.

Incorrect cumulative values when date slider is connected.

[v-jiascu-msft]

Hi @paulcar ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft]

Hi @paulcar ,

Please try @Greg_Deckler 's idea. If you still have issues, please share a sample file without any confidential parts.

Best Regards,

[Greg_Deckler]

Likely need an ALL instead of an ALLSELECTED somewhere in your formula. You generally have to remove the context and then put your own context back in.