Calculate Past Due Backlog Over Time

Hi aallman 

First , you need create a date table to compare with Due date and Ship date . You can extract date from your sample data table . Create a calculated table like this :

Table 2 = CALENDAR(MIN('Table'[Due Date]),MAX('Table'[Ship Date]))

You will get a table like this :

Then create measures to return the sum and count .

Sum = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Due Date]<MIN('Table 2'[Date])&&'Table'[Ship Date]>=MIN('Table 2'[Date])))

count = CALCULATE(COUNT('Table'[Value]),FILTER(ALL('Table'),'Table'[Due Date]<MIN('Table 2'[Date])&&'Table'[Ship Date]>=MIN('Table 2'[Date])))

You will get the result you want .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.