Forum Discussion
Slicer/AND not OR
Hello - I have a large data set of individuals each with five traits associated with them from a list of about 40 traits. I'd like to use a slicer to select traits and identify individuals with those traits. Right now if I select two traits using the slicer and the ctrl button - I get a list of individuals with either of the traits instead of a list of individuals with BOTH of the traits - am I overlooking something simple?
HI AA364,
In fact, these filter work as expected. The default filter/slicer does not support this type of filter interaction.
You need to create a Dax expression to extract the selection from filter and check the row content to return flag. Then you can use this on visual level filter to filter result flag to indirectly achieve AND logic on the filter selection items.
If you are confused about coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
2 Replies
- BITomS
Solution Supplier
HI AA364,
In fact, these filter work as expected. The default filter/slicer does not support this type of filter interaction.
You need to create a Dax expression to extract the selection from filter and check the row content to return flag. Then you can use this on visual level filter to filter result flag to indirectly achieve AND logic on the filter selection items.
If you are confused about coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
