Forum Discussion

Dalen's avatar
Dalen
Frequent Visitor
7 years ago
Solved

MULTIPLE FILTERS WITH OR CONDITION

Hi Everyone,   I have been looking for a way to make a custom slicer that filters on AND instead of OR, so far unsuccessfully. Below is some example data to further describe what I am looking for. ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Dalen ,

     

    There is a workaround. Please download the demo from the attachment. 

    1. Add a new column to connect two fields.

    2. Create a new table.

    3. Create a new measure as a Flag.

    Flag =
IF (
    ISFILTERED ( FruitStatus[Column] )
        && CALCULATE ( COUNT ( Table1[Column] ), ALL ( Table1[Fruit], Table1[Value] ) )
            = CALCULATE ( COUNT ( FruitStatus[Column] ), ALLSELECTED ( FruitStatus[Column] ) ),
    1,
    BLANK ()
)

    MULTIPLE-FILTERS-WITH-OR-CONDITION

     

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Dalen ,

 

There is a workaround. Please download the demo from the attachment. 

1. Add a new column to connect two fields.

2. Create a new table.

3. Create a new measure as a Flag.

Flag =
IF (
    ISFILTERED ( FruitStatus[Column] )
        && CALCULATE ( COUNT ( Table1[Column] ), ALL ( Table1[Fruit], Table1[Value] ) )
            = CALCULATE ( COUNT ( FruitStatus[Column] ), ALLSELECTED ( FruitStatus[Column] ) ),
    1,
    BLANK ()
)

MULTIPLE-FILTERS-WITH-OR-CONDITION

 

 

Best Regards,