Filtering table based on date table where selected date is between 2 date columns

I'm not sure I have explained what I am trying to do very well, so I thought I'd provide another update on this with the hopes its a bit more clear with examples.

In the screenshot below, I have my data table on the left and a list of dates on the right.  What I'd like to do is be able to select a date from the date table, like 01/07/2022 as shown in the screenshot, and the table on the left will filter based on this data if the data falls betwen the Valid From Date and the Valid To Date.

I managed to create the measure from my initial post but that only works if you apply it to visual filter in the filter pane, I can't apply it to the page or all pages.  In the report that I'm working on I have 13 visiuals / elements so applying it to each one is a bit risky.  We will be converting our Data Warehouse to be using Valid From and Valid To dates for all of our tables, so we need a solution to all the user to show what the data would show on the selected date.

I may be approaching this in completely wrong way, so I'm happy to hear peoples ideas as I'm a but stumped on what I can