Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
67 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |