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 ...
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.

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.