Trying to Understand Advanced Filtering

[NoelaniRoy]

Hi all,

This is probably a simple questions, so thank you in advance for your patience.

I am trying to understand how the advanced filter "AND" works.

Let's say I have a the following table:

Letter	Animal
A	cat
A	dog
B	cat
B	goat

If I filter the Animal column to "cat", it returns:

Letter	Animal
A	cat
B	cat

if I filter the Animal column using advanced filtering to "Show items when the value is "cat" OR is "dog", it returns:

Letter	Animal
A	cat
A	dog
B	cat

when I filter the Animal column using advanced filtering to "Show items when the value is "cat" AND is "dog", it returns nothing. Why would it not return just A? What am I doing wrong / is there a way to return A using this expandable filter pane?

Thank you very much in advance for your time!

Best,
Noelani

[AlexisOlson · Accepted solution]

It returns nothing because an animal cannot be simultaneously a cat and a dog even if both correspond to the letter A. The filtering is on Animal, not on Letter, so it's irrelevant what the letter is.

There are ways to filter like you were expecting using measures but I don't think it can be done directly in the filter pane without defining a new measure.

[NoelaniRoy]

Thanks for the speedy reply Alexis. What you said makes sense.