Forum Discussion

megskilton's avatar
megskilton
Frequent Visitor
9 years ago
Solved

Anti Filtering

I'm wanting to use a slicer, but the data that is displayed (In a table) is the data that isn't in the filter selection, rather the results that haven't been included in the filtering.     
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi megskilton

     

    Change the following 

     

    5. Create a measure called SelectedBrand =  Values(BrandSelect[Brand])

             as 

              SelectedBrand  =       If(HASONEFILTER((BrandSelect[Brand])), Values(Brand[Select]), Blank())

     

     

    6. Create a measure called ShowYes

       ShowYes = IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes")

       

    as 

    ShowYes = IF(HASONEFILTER((BrandSelect[Brand])),
                                         IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes"),"Yes")

     

    Try it out and let me know if you run into issues.

     

    Cheers

     

    CheenuSing

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi megskilton

 

Change the following 

 

5. Create a measure called SelectedBrand =  Values(BrandSelect[Brand])

         as 

          SelectedBrand  =       If(HASONEFILTER((BrandSelect[Brand])), Values(Brand[Select]), Blank())

 

 

6. Create a measure called ShowYes

   ShowYes = IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes")

   

as 

ShowYes = IF(HASONEFILTER((BrandSelect[Brand])),
                                     IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes"),"Yes")

 

Try it out and let me know if you run into issues.

 

Cheers

 

CheenuSing

megskilton's avatar
megskilton
Frequent Visitor
9 years ago

Thank you Anonymous,

 

Thats works well, Just one more question- Is there a way I am able to select two or more of the options from the slicer and these would also be excluded?

 

Many Thanks

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi megskilton,

    If you select the mutiple value in slicer, it's different todetermine which will be used in if function.

    Thanks,
    Angelia Zhang

    • Keshav's avatar
      Keshav
      Regular Visitor
      8 years ago

      Will you please let me know how to achieve anti slicer with mulltiple values selected... in direct query mode