Make slicers filter using AND condition

[Anonymous]

I have a scenario where the report users will need to select a number of qualifications from a slicer. this slicer should filter a list of people who have ALL of those qualifications. Right now with slicers I seem to only be able to get the slicer to apply OR with multi select. 

So right now if the user selects qualifications A, B, C, anyone with any of those qulaifications  comes up. I only want it to show people with A AND B AND C. 

Any help would be great 🙂 

[v-xiaotang · Accepted solution]

Hi @Anonymous 

>> So right now if the user selects qualifications A, B, C, anyone with any of those qulaifications  comes up. I only want it to show people with A AND B AND C. 

See example below.

Sample data:

at the beginning when you select qualifications A, B, C, anyone with any of those qulaifications  comes up.

then create the measure below and put it into visual-level slicer, 

Measure = 
var _t1= ALLSELECTED(Slicer[qulaification])
var _t2=SELECTCOLUMNS( FILTER(ALL('Table'),'Table'[people]=MIN('Table'[people])),"q",[qulaification])
var _t3= INTERSECT(_t1,_t2)
var _count1= COUNTX(_t1,[qulaification])
var _count2= COUNTX(_t3,[qulaification])
return IF( _count1=_count2,1)

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[nickolajj]

Try this:

Basically just counting the amount of selections in the slicer and comparing them to the number of skills of a worker (where the number of skills for a worker is filtered by the slicer, so it should work out)

[ribisht17]

@Anonymous 

Do you mean like this >> Solved: Filter with And Condition using slicer - Microsoft Power BI Community

Regards,

Ritesh