measure interacts with slicer

Hi Julia2023 

Measures are evaluated in the filter or query context - they don’t inherently have a row context. When you place a measure alongside a date column, the visual evaluates the measure for each date, so you can filter it down to either 1 or 0 - or for all the rows or visible rows of a column or table depending on the filter modifier applied (ALL, ALLSELECTED).

However, in visuals where you can’t directly add dimensions (like KPIs, old-style cards, etc.) or when another dimension is being used, you’ll need to wrap the original measure inside a new one. That way, the measure can still be evaluated properly in the given context. For example:

CALCULATE ( [sales], FILTER ( VALUES ( 'Date'[sort] ), [Qtr Selector] = 1 ) )

Note: While the measure below will still work it is generally more expensive and is a best practice to filter a column instead of the whole table.

CALCULATE ( [sales], FILTER ( 'Date', [Qtr Selector] = 1 ) )

Hi, Julia2023 here is some few case where your measure is not working or returning any results 

•  SELECTEDVALUE('Date'[Sort]) it only works when there's a single value selected, so if you select more than one it will not work. 
• And comparison > 99999 seems arbitrary and may not work as intended
  You can try this 

Qtr Selector Fixed =
VAR CurrentQtrSelection =
    CALCULATE(
        MAX('Date'[Sort]),
        FILTER(
            ALL('Date'),
            'Date'[Is Next Qtr +1] = "Yes"
        )
    )
VAR CurrentSort = 
    IF(
        HASONEVALUE('Date'[Sort]),
        VALUES('Date'[Sort]),
        BLANK()
    )
RETURN
IF(
    NOT ISBLANK(CurrentSort) && 
    (CurrentSort <= CurrentQtrSelection || ISBLANK(CurrentQtrSelection)),
    1,
    0
)