Calculate Max and Min Dates Selected Ignoring other Slicer

[Anonymous]

All I want to do is create a measure that will show me the min date in my date slicer, but the other slicers keep causing it to give me different results. 
I have a table called 'ALl Events' which has columns 'event_start_date' and 'location'. I have slicers for each of these columns and want to have a a measure that will show me the max date on the 'event_start_date' slicer regardless of 'location' slicer. Some locations do not have events every day so it will show me a later date than anticipated. Here's an example:

var MaxDate=CALCULATE(MaxX('All Events','All Events'[event_start_date]),ALLSELECTED('All Events'[event_start_date]))

RETURN MaxDate

 This is the result I get - but it should be 9/17/2024

I also tried this code with the same results

var MaxDate=CALCULATE(MaxX('All Events','All Events'[event_start_date]),ALLEXCEPT('All Events','All Events'[event_start_date]))

RETURN MaxDate

[Anonymous · Accepted solution]

I figured out the solution to my own problem - in case anyone else is having the same issue, I think it has something to do with auto-exist: https://www.sqlbi.com/articles/understanding-dax-auto-exist/

To solve it I created a dimension table for location with a one -many relationship with my Events table. I then used the Dimension[location] column as my slicer instead of the one from my Events table. Then the measure using "ALLEXCEPT" worked!