Measure to calculate and not go past max date based on page filter

[Leasie_7]

Hello - I'm still very new to this...

I have a report where we provide monthly or quarterly or yearly data based on a page filter. On this report I have a visual that provides [Total Resolved] for the current year or even sometimes we show the last three years and this works.....However I would like the visual (column graph) to not show any [Total Resolved] numbers past the last calendar date based on the page filter. 

For example I have the Month filtered on the page for September 2022 I would like the column graph to not show any [Total Resolved] for the month of October 2022 as I want to show only up to Septemebr 2022 numbers based on the filters. Not sure if this information is necessary, but there are 3 date filters for the page a dynamic [This/Last Month], [This/Last Quarter] and [This/Last Year] that could be selected and I would like the graph to adjust according to the max date based on these page filters. 

Currently my measure that works ignoring the filters, but giving me past my date page filters is:

Total Resolved IGNORE DATE PAGE FILTERS = CALCULATE([Total Resolved],ALLEXCEPT('Calendar Table','Calendar Table'[Date].[Month],'Calendar Table'[Date].[Year]))

The one column highlighted below (October 2022) is what I would like to show blank as based on the LastDateValue = CALCULATE(MAX('Calendar Table'[Date])) which returns 09/30/2022 I would want to exclude it and if anything were after it. 

Do I need to add a filter in the measure or summarize a table? I have no idea. Any help would be appreciated and if anyone has any idea on how to have a measure ignore a custom date hierarchy for the above so I can shorten the months to "mmm" that would be great I have been unsuccessful getting it to ignore the page filter with using a custom hierarchy. 

Thank you in advance for any guidance. 

[lbendlin]

Read about the FILTERS function and incorporate that into your measures. To suppress certain data point have the measure return BLANK() for them.

[Leasie_7]

Appreciate the response. I do understand how FILTERs work, but I have trouble with it then applying ALLEXCEPT in the same instance as it will only show the [Total Resolved] for September (the month value selected in the page filter). 

Any advice?