Getting a rolling average based on total vs. total days?

[Imthedan]

Hello,

I am trying to get a simple average that is based on how many days have been ran in my time period. I'd want to get 177 divided by 4 (since there have been four Fridays). Since five total Wednesday's have been ran, I'd want to get the total of Wednesday divided by 5. 

I need this to be a rolling average as well, so it updates based on the calendar updating. 

Thank you for your help!

[amitchandak]

@Imthedan , Isincope should help

assume you have measure then try like

Sub Total= calculate(averagex(values(Date[Date]),[measure]) ,filter(allselected(Date), Date[Day Name] = max(Date[Day Name])))

FInal measure = if(isinscope(Date[Day Name]) && not(isinscope(Date[Date])), [Sub Total], [Measure])

[Imthedan]

I put in the code and got an error saying the filter function passed too few arguments. 

Here is the code I used: 

Sub Total = CALCULATE(AVERAGEX(VALUES(LU_Calendar[Date]),[Total_Test]),FILTER(ALLSELECTED(LU_Calendar[Date],LU_Calendar[Day Name] = MAX(LU_Calendar[Day Name]))))

Do you see the issue?

Thank you!