Slicer/AND not OR

[AA364]

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?

[Anonymous · Accepted solution]

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

[BITomS]

Hi @AA364,

This video may be helpful: https://www.youtube.com/watch?v=tONOosN1xAs