Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

WTD Calculation does not work with filters

I am trying to modify the following DAX so that it will work with my filter for brand.  Currently, it will calculate for all brand but not for each brands seperately.   BookingWTDCurrent = VAR _...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    BookingWTDCurrent =
VAR _CurrentDate = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] )
VAR _CurrentWeekYear = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[WeekNo])
RETURN
CALCULATE(
'Daily Bookings RY'[RY BKGS],
ALLEXCEPT(DSH_DAILY_BOOKINGS_GRAPH[Brand]),
DSH_DAILY_BOOKINGS_GRAPH[WeekNo] = _CurrentWeekYear,
DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] <= _CurrentDate )
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago
BookingWTDCurrent =
VAR _CurrentDate = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] )
VAR _CurrentWeekYear = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[WeekNo])
RETURN
CALCULATE(
'Daily Bookings RY'[RY BKGS],
ALLEXCEPT(DSH_DAILY_BOOKINGS_GRAPH[Brand]),
DSH_DAILY_BOOKINGS_GRAPH[WeekNo] = _CurrentWeekYear,
DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] <= _CurrentDate )