Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
Employee

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
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.