Apply Filter before Calculating Average

Your visual-level filter measure is evaluated at the current visual grain (Product-State), not at the underlying Product-State-Date row level, so it won’t exclude date rows first. Use the threshold condition inside each aggregation measure instead:

Threshold % = 0.11

Sales (Filtered) =
VAR T = [Threshold %]
RETURN
CALCULATE(
    SUM('Fact'[Sales]),
    KEEPFILTERS( FILTER('Fact', 'Fact'[Damage%] < T) )
)

Costs (Filtered) =
VAR T = [Threshold %]
RETURN
CALCULATE(
    SUM('Fact'[Costs]),
    KEEPFILTERS( FILTER('Fact', 'Fact'[Damage%] < T) )
)

Damage % (Filtered) =
VAR T = [Threshold %]
RETURN
CALCULATE(
    AVERAGE('Fact'[Damage%]),
    KEEPFILTERS( FILTER('Fact', 'Fact'[Damage%] < T) )
)

Hi,

PBI file attached.

Hope this helps.