Forum Discussion

rakunn's avatar
rakunn
Frequent Visitor
8 years ago
Solved

Can I create filter with overlapping values?

Hello data heroes!   I would like to ask if there is a possibility to create filter with overlapping values? Let's say, I have a table with cars and their statuses:   CarID Status 1 Rent ...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi rakunn,

     

    You should have a single table to list all available slicer selections.

     

    Create a measure. And add it to visual level filter, set its value to 1.

    Check_Measure = 
IF ( ISERROR(FIND(SELECTEDVALUE ( Table7[Column1] ) ,LASTNONBLANK(Table6[Status],1 ))), 0, 1 )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi rakunn,

 

You should have a single table to list all available slicer selections.

 

Create a measure. And add it to visual level filter, set its value to 1.

Check_Measure = 
IF ( ISERROR(FIND(SELECTEDVALUE ( Table7[Column1] ) ,LASTNONBLANK(Table6[Status],1 ))), 0, 1 )

 

Best regards,

Yuliana Gu