Forum Discussion
Cumulate quantity
Hi janainacarmo ,
This cumulative count works in dashboard and works with a time slicer and a program slicer.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Cumulative Count of Customers =
VAR MaxDate = MAX ( aver[Date] )-- Saves the last visible date
var Counter =
CALCULATE (
[Count of customers], -- Computes customers
aver[Date]<= MaxDate, -- Where date is before the last visible date
ALLEXCEPT( aver,aver[Program] ) -- Removes any other filters from Date allexcept aver([Program]
)
return Counter- janainacarmo6 years agoRegular Visitor
Dear Nathaniel_C ,
Thank you for your reply, but it still not working properly...the cumulative is working fine, but when I change the períod for 2017-2019, it still being summing the value from 2016. The total from the first year, in the period that I chose in the time slicer, should not be cumulative. I attached two prints (períod 2016-2019 and 2017-2019) and highlighted them in yellow as you can see.
https://drive.google.com/drive/folders/1TBOsDKqiGUfnsGZugNfcZfF4-OiDCtYm?usp=sharing
Thank you for your support until now.
Best Regards, Janaina