Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

OR condition on multiple slicer selections

I have a streaming dataset dashboard that 6 slicers currently available for a table of data. The 6 slicers each represent a different column in the table but I need them to act as OR's and not AND's...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    I made a simple document to illustrate it.

    1.The first step is to have 6 tables independent of each other, without any relationship (my file here is using two slicers, so two tables)

    2.Then create a measure.

    flag = IF(MAX('Table'[column1]) in ALLSELECTED(slicer1[column1])||MAX('Table'[column2]) in ALLSELECTED(slicer2[column2]),1,0)

    3.apply the flag measure into filter.

    The final output is shown below:

    If you also not clear, can you share me the simplr file after removing the sensitive information?

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

I made a simple document to illustrate it.

1.The first step is to have 6 tables independent of each other, without any relationship (my file here is using two slicers, so two tables)

2.Then create a measure.

flag = IF(MAX('Table'[column1]) in ALLSELECTED(slicer1[column1])||MAX('Table'[column2]) in ALLSELECTED(slicer2[column2]),1,0)

3.apply the flag measure into filter.

The final output is shown below:

If you also not clear, can you share me the simplr file after removing the sensitive information?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi_world's avatar
hi_world
Helper III
3 years ago

Hello v-yalanwu-msft , 
amazing solution ! Bravo

Do you know a way to do it without create multiple table each table for slicer ? 
Or maybe create table in dax and use it in the same flag measure ? 
Best regards