Forum Discussion
Trying to Understand Advanced Filtering
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.
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.