Average days outstanding for tickets as of specific date

[za]

I am trying to figure out Dax for Average Days Outstanding taking into account all tickets that are open as of spec date to show trend over time. 
How many days tickets are outstanding on average over the period of time and what is days outstanding on tickets as of 8/25/2020? 
Per example below, I have manually calculated in excel the outcome that I am looking for but do not know how to create dax formula to reflect that. As you can see, in my average formula I am taking into consideration all tickets that have current balance >0 as of 8/25/2020 and giving average counting prior rows ( prior tickets open as of 8/25/20). 
Currently, I know to how to calculate DAX days oustanding which is diference between ticket dates and today on tickets with current balance >0 but I do not know how to include in my DAX pror days where tickets are outstanding as well. 

Your help is greatly appreciated!

[amitchandak]

@za , Try a measure like

averageX(summarize(filter(Table, table[current balance]>0), table[ticket] ,"_1", datediff(today(), min[ticket date], date)),[_1])