Forum Discussion

amitkhare82's avatar
amitkhare82
New Member
8 years ago

Slicer Filtering the multi selected values search exact value

Hello All,   I'm running into something that may be a very common issue but cannot get it through.   Here is my situation. 1.  A Slicer table- Device Device ID DeviceName 1 New Device  ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi amitkhare82,

 

Based on my test, you should be able to use the formula below to create a new measure, then use it to apply a visual level filter(IsFiltered is 1) on the Table visual which shows the projects to get the expected result in your scenario.

IsFiltered = 
IF (
    SUMX (
        'Device',
        FIND ( 'Device'[DeviceName], MAX ( Projects[Related Devices] ),, 0 )
    )
        > 0,
    1,
    0
)

Note: make sure there is no any relationship between the two table.

 

Here is sample pbix file for your reference. :smileyhappy:

 

Regards

amitkhare82's avatar
amitkhare82
New Member
8 years ago

Thank you v-ljerr-msft

Yes, My formula works with a limited set of data. I sent the samples of data but in my thousands of records, My Device Name slicer shows the Blank too. If I select two values from filter , it doesn't filter the correct records but If I select the Blank along with other values (one or more )it works with the same Measured column. I tried to hide the Blank in filter but it didn’t work either. 

 

I suspect that due to some or many records having the blank values of related devices, the formula based "Measured column" doesn't work the way it would work. Although my Device Table doesn't have any blank record.

 

Thank again for looking into this.