Forum Discussion

analyticsyc's avatar
analyticsyc
Frequent Visitor
2 years ago
Solved

AND vs OR in Advanced Filters

I am using an Advanced Filter on a lookup table with a column called ProductClass. See the screenshot:   Can anyone explain why when I use 'OR', the underlying data doesn't change. Its as if ...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    analyticsyc 


    I believe I understand now. You're using "Does not equal to," which negates the condition, indicating that you want to exclude certain values. Therefore, Power BI's interpretation is correct.

    In my example, I utilized "Starts with," which aligned with my intended outcome.

     



     

Fowmy's avatar
Fowmy
Super User
2 years ago

analyticsyc 

The way you have understood and explained, yes it is correct. I also tested but it is working correctly. check my screenshot below. Please recheck your result how you got right with AND.

 

analyticsyc's avatar
analyticsyc
Frequent Visitor
2 years ago

Fowmy 

 

Thanks for your response. I agree that your example seems to be working as expected. I've provided additional screenshots showing how it doesn't work for me:

Filter applied with 'OR':


Filter applied with 'AND':


Would you mind testing something for me? If you do 3+ arguments in the advanced filter (first select 3+ items in basic filter, then switch to advanced and it should give you the option for 3+ advanced filters), does the 'OR' operator still work for your data?

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    analyticsyc 


    I believe I understand now. You're using "Does not equal to," which negates the condition, indicating that you want to exclude certain values. Therefore, Power BI's interpretation is correct.

    In my example, I utilized "Starts with," which aligned with my intended outcome.