Forum Discussion

Imthedan's avatar
Imthedan
Icon for Helper II rankHelper II
5 years ago

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

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 Wed...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Imthedan
Icon for Helper II rankHelper II
5 years ago

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!