Dynamic calculated column to categorize date based on slicer

[Anonymous]

I'm trying to create a calculated column for my DIM_DATE which indicates which range does the date for into ("Last 7 days", "Last 8-14 days", "Last 15-21 days") based on my single selected date slicer. For instance, if I choose June 10, 2022, the column would show "Last 7 days" for June 5 and "Last 8-14 days" for June 1. 

The filter is based on DIM_DATE[THEDATE] column.

My current DAX formula is:

Date Category =

VAR SelectedDate = SELECTEDVALUE(DIM_DATE[THEDATE])

RETURN

SWITCH(TRUE(),

DIM_DATE[THEDATE] <= SelectedDate && DIM_DATE[THEDATE] > SelectedDate - 7, "Last 7 Days",

DIM_DATE[THEDATE] <= SelectedDate - 8 && DIM_DATE[THEDATE] > SelectedDate - 14, "Last 8-14 Days",

DIM_DATE[THEDATE] <= SelectedDate - 15 && DIM_DATE[THEDATE] >= SelectedDate - 21, "Last 15-21 Days","Other")

However, it is showing for all dates in my table to fall under "Other". Please refer to the picture below and let me know what is going wrong. Thanks!

[Anonymous]

Calculated columns and calculated tables are evaluated once when the data is loaded and are static until the data is refreshed.