Week of Column Header indicator missing/filtered data

If I have a column of dates, associated with a column of "week of" that in itself is the MIN(calendar_date) - MAX(calendar_date) for each week, and the user has applied a Month filter (lets say November as an example), is there a way I can have a measure OR column that displays a slightly changed header showing that specific column is missing dates?

Example

Week of 10/27/2024 - 11/02/2024 when filtered by Month = November would only aggregate the data from 11/01 - 11/02. 

Can the header instead show Week of 10/27/2024 - 11/02/2024*

Alternatively it could instead use the filtered MIN/MAX as Week of 11/01/2024 - 11/02/2024

I had a measure created that was doing it correctly in a table on rows (as long as I had the related column [Week] as well, but I couldn't use the measure as a "column". I've tried SUMMARIZE and SUMMARIZECOLUMNS, but it's not cooperating. 

That's the general structure of underlying data. Months are setup as a slicer with current month pre-filtered and the view is month over month aggregate data. If the user switches to see a week over week view it would look like this:

It's not immediately clear that the week of 10/27-11/02 is filtering out the data from October.