cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulcar Frequent Visitor
Frequent Visitor

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.

DAX1.PNGIncorrect cumulative values when date slider is connected.
3 REPLIES 3
Super User
Super User

Re: What's wrong with my Cumulative code?

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. 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: What's wrong with my Cumulative code?

Hi @paulcar ,

 

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

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: What's wrong with my Cumulative code?

Hi @paulcar ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.