I have a measure that works using summarize. Now, I need to create the same measure based on fiscal week to date. I can create a WTD measure no problem, but not sure how to combine with Summarize.
Can someone please point me in the right direction?
Average Product Line Budget By ProductLine USD =
[Average Product Line Budget USD] ),
Example Fiscal WTD Measure:
Budget USD Fiscal WTD =
var _selectedFiscalWeek= SELECTEDVALUE(Dates[FiscalWeekNumber],0)
var _selectedFiscalYear= SELECTEDVALUE(Dates[FiscalYearOnly],0)
var _dayofWeek= SELECTEDVALUE(Dates[DayOfWeekNumber],0)
Filter(All(Dates),Dates[FiscalWeekNumber]= _selectedFiscalWeek && Dates[FiscalYearOnly]= _selectedFiscalYear && Dates[DayOfWeekNumber] <=_dayofWeek)