Forum Discussion
What's wrong with my Cumulative code?
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.
Incorrect cumulative values when date slider is connected.
3 Replies
- Greg_Deckler
Community Champion
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.
v-jiascu-msftMicrosoft Employee
Hi paulcar ,
Please try Greg_Deckler 's idea. If you still have issues, please share a sample file without any confidential parts.
Best Regards,
- v-jiascu-msft
