Forum Discussion

Angelo's avatar
Angelo
Regular Visitor
8 years ago
Solved

Filtering Results

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...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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. :smileyhappy:

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

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

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. :smileyhappy:

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

 

Regards