Forum Discussion

niberxz's avatar
niberxz
Regular Visitor
9 years ago

Cumulative issue

Hello everyone, I am trying create an acomulative sum by date but recently I found a issue using this: CALCULATE(DISTINCTCOUNT(Gestion[GesTot]),FILTER(all(Gestion),Gestion[FecGestion]<=max(Gestion[...
Need Help
MalS's avatar
MalS
Resolver III
9 years ago

Is "Gestion[FecGestion]" your Date field in your calendar table, because that's what you need for a cumulative sum. Here's a great explanation of the pattern: http://www.daxpatterns.com/cumulative-total/  

 

Also, you say you want to do a sum, but you are using DISTINCTCOUNT - is that intentional?