cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angelo
Regular Visitor

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 

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

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

 

Regards

View solution in original post

1 REPLY 1
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

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

 

Regards

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors