Filtering Results

[Angelo]

Hi Guys

How do I create a measure that when selecting two or more variables from a filter it always selects a specific variable.

For example if I have Scenario A, B and C and I filter A and B I want it to only filter A etc etc.

Thanks 

[v-ljerr-msft · Accepted solution]

Hi @Angelo,

If I understand you correctly, you should be able to use ALL function in FILTER to create the measure. The formula below is for your reference. 

Measure =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( ALL ( Table1 ), Table1[Scenario] = "A" )
)

Regards