WTD Calculation does not work with filters

[DMatlock06]

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 _CurrentDate = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] )

VAR _CurrentWeekYear = SELECTEDVALUE(DSH_DAILY_BOOKINGS_GRAPH[WeekNo])

RETURN

CALCULATE(

'Daily Bookings RY'[RY BKGS],

FILTER(ALL(DSH_DAILY_BOOKINGS_GRAPH),

DSH_DAILY_BOOKINGS_GRAPH[WeekNo] = _CurrentWeekYear &&

DSH_DAILY_BOOKINGS_GRAPH[REQUEST_DATE] <= _CurrentDate )

)

All brands

Filtered by Brand

[lbendlin · Accepted solution]

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 )