Time intelligent measure - cumulative total with conditons

[krishna0]

Hello!

I have already grouped dataset by partnumber and ordernumber, with max procure, max assigned and max received.

This is a current chart, which simply shows the count of each item per week they are in:

What I am trying to achieve is a measure, that takes "procure" and "assigned" dates and counts rows respectively: let's say, that we're looking on week 202214. I want to have a cumulative total of rows, for which "procure" that is LATER so 202215 and further OR blank and in the same time "assigned" is EQUAL or LESS than the current week, so 202214, 202213 etc.

I tried some ways but it does not work as designed. There is probably no case "assigned" later than "procure" in my current dataset. If you have any ideas I would really appreciate it. Here is the workbook I am working on:
https://drive.google.com/file/d/13ILpKAsLYNNhZMGN4OPP0YwglQzP89L2/view?usp=sharing

Best Regards

[krishna0]

This looks very good! Thank you!

[tamerj1 · Accepted solution]

@krishna0 
Not sure if this is what you're looking for

cumulative total = 
CALCULATE ( 
    COUNTROWS ( Sheet1 ), 
    COALESCE ( Sheet1[procure], TODAY ( ) ) > MAX ( 'Calendar'[Date] ), 
    Sheet1[assigned] <= MAX ( 'Calendar'[Date] ),
    REMOVEFILTERS ( 'Calendar' ) 
)