Filter visualizations by measure value AND column value

I need to filter my visualizations by a measure value and a column value. Visual filters appear to only allow filtering the measure by the measure value. In any case, this approach would not be ideal since it would have to be applied to each and every visual.

The measure that requires filtering ([Scenario TRC Ratio]) uses the DIVIDE function on two other measures that include what-if parameters. Only the results where Forecast[Activity]<>"B" AND [Scenario TRC Ratio] < 1.0  should be excluded, where:

Scenario TRC Ratio = DIVIDE([Scenario Benefits]|[Scenario TRC Cost]|0)

Scenario Benefits = SUM(Forecast[Benefits]) * (1+[Parameter1])

Scenario TRC Cost = CALCULATE(
SUMX(Forecast|IF(Forecast[Sector]="AA"|Forecast[TRC Cost]+DIVIDE(MAX(Parameter2[Parameter2])|POWER(1.0766|2))|Forecast[TRC Cost])
)
)

and the Forecast table looks something like this: