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()))
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]))
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!