Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Make slicers filter using AND condition

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 🙂 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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)

     

     

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.