Forum Discussion
Trying to Understand Advanced Filtering
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
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.
2 Replies
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.
Thanks for the speedy reply Alexis. What you said makes sense.
