Hi Sam,

I am trying to do something similar to this video but with Avg of Total Sales (by Work Days).

1st, I calculated the total work days:

`Work days = CALCULATE(COUNTROWS(FILTER('Date','Date'[Holidays & WorkDays] = "Work Day")), FILTER('Date','Date'[Date] < TODAY()))`

2nd,

`Avg Sales per Work day = DIVIDE([Total Sales],[Work days])`

3rd - This part is not doing what it supposed to do. It’s not summing “Avg Sales per Work Day” by FY.

`Avg daily sales per FY (all) = CALCULATE([Avg Sales per Work day], ALL('Date'[FY]))`

4th

`Avg Sales % = DIVIDE([Avg Sales per Work day],[Avg daily sales per FY (all)],0)`

I am missing something very simple but can’t figure out what. Please help!

Kiran