Filter table on a combination of multiple column selections

[jdog05]

Hi, we have a scenario were users need to filter a table based on a combination of columns B & C selections with column C being a range of values. Haven't found a solution that works so hoping someone in the communtity can help.

Hope this example is clear, thanks! 

[v-linhuizh-msft · Accepted solution]

Thanks for the reply from Idrissshatila.

Hi @jdog05 ,  

Using the sample data you gave me, I achieved your desired effect by creating two new tables for columns B and C respectively that have no relation to the original table, here are my steps:

1.Use the VALUES function to create new tables for columns B and C to use as slicer fields.

B1 = VALUES('Table'[B])

B2 = VALUES('Table'[B])

C1 = VALUES('Table'[C])

C2 = VALUES('Table'[C]) 

2.Create four slicers:

 

3.Create a meausre and filter the table:

Measure =
IF(
    (
        (SELECTEDVALUE('Table'[B]) = SELECTEDVALUE('B1'[B]) &&
        SELECTEDVALUE('Table'[C]) >= MIN('C1'[C]) &&
        SELECTEDVALUE('Table'[C]) <= MAX('C1'[C]))
        ||
        (SELECTEDVALUE('Table'[B]) = SELECTEDVALUE('B2'[B]) &&
        SELECTEDVALUE('Table'[C]) >= MIN('C2'[C]) &&
        SELECTEDVALUE('Table'[C]) <= MAX('C2'[C]))
    ),
    1,
    0
)

4.The final result is as follows:

 

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[jdog05]

thanks @v-linhuizh-msft this works perfectly, really appreciate your help 😉

[Idrissshatila]

Hello @jdog05 ,

then you can add two slicers, first one is a drop down slicer that shows the data of column B and the second is a between slicers.