Forum Discussion

benjamin_sasin's avatar
benjamin_sasin
Resolver I
6 years ago
Solved

Cumulative Count Decreases?

Hi,   I'm a little confused after running a cumulative count, to find that the number is decreasing at some point:   The formula is: Cumulative Count = CALCULATE(COUNT('Admissions'[email]),FILT...
Need Help
  • benjamin_sasin's avatar
    benjamin_sasin
    6 years ago

    Okay I figured it out. As usual it as a silly mistake on my part.

     

    As I observed a mismatch between date a cumulative count, I realise the name fo the date in the formula [startedApplicationAt] wasn't the same as in the report [latest_stage_date], which is the one in the axis of the visual.

     

    So obviously the cumulation wasn't synced with dates... *facepalm*.

     

    Sorry for wasting your time and thanks for sharing your neurons. I probably wouldn't have seen it alone.

dax's avatar
dax
Community Support
6 years ago

Hi benjamin_sasin, 

Yes, if possible, could you please inform me more detailed infromation for me (such as your sample data or your pbix file)? In addition, you also could check whether the category has negative value in it.

 

Best Regards,
Zoe Zhi

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

  • benjamin_sasin's avatar
    benjamin_sasin
    Resolver I
    6 years ago

    Hi I'm sorry, for data privacy reasons I cannot share the pbix file. 

     

    There are no negative categories: it is counting text (emails) against dates.

     

    As with sample data shown above, there is a number of anomalies, where the cumulated count is going down instead of increasing. See dates 26 December or 31 December for example.