Include values leading up to and including Date selected

[patri0t82]

I have a measure in Power BI:

Q3 Mechanical Availability = 
CALCULATE(
    IF(
        ISBLANK( SELECTEDVALUE( 'Operational - Mechanical Availability'[Quarterly Average] ) ), 
        BLANK(), 
        SELECTEDVALUE( 'Operational - Mechanical Availability'[Quarterly Average] )
    ),
    CONTAINSSTRING('Operational - Mechanical Availability'[Quarter], "Q3")
)

The table  'Operational - Mechanical Availability' has a [Date] column connected to CalendarTable[Date].

I have a dropdown slicer for CalendarTable[Month Name]. So, when I select "July" (or August, or September), this measure shows me the [Quarterly Average] for any of those months.

The problem is, if I select December, this measure displays Blank(), as it is currently built. Because these [Dates] are BEFORE December I would like them to appear.

If I select March, this measure should be Blank()

[patri0t82 · Accepted solution]

Thank you but I think the most effective solution is to just Edit the Interactions and their connections.