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 I want it to only filter A etc etc.

 

Thanks 

  • 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

1 Reply

  • 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