¿How to Perform cumulative count of rows based on calculations?

[brissae]

Hello everyone,

I have a dataset containing the Order column, date received and date shipped. I need a report where I can see the number of orders received and shipped every month and also the difference between them in order to understand how many orders are getting stucked. 

But now, I have to acumulate the on hold totals, I have been trying some dax formulas but nothing seems to work, the on hold colum comes from a measure. At the end I need to have this:

Any idea? Thank you in advance.

[Vvelarde]

Hi @brissae

Acum-Onhold = CALCULATE([Onhold];FILTER(all(Calendar);Calendar[Month]<= MAX(Calendar[Month])))

[brissae]

@Vvelarde keeps on giving me the same result: 

ACUM = CALCULATE([ONHOLD],FILTER(ALL('CALENDAR'),'CALENDAR'[Month] <= MAX('CALENDAR'[Month]))) I've been trying with this measure all day but nothing changes, any other idea?

Thanks

I

[Vvelarde · Accepted solution]

@brissae

I test this and Worked,

If i delete the "all" in the filter give me the result that you put in previous post.

TO give you another solution, Can you share a PBIX with your structure or sample?