I want to eliminate the selected values from Slicer one to show only remaining values in 2nd Slicer.

[Anonymous]

I have two slicers with the same column 'Table'[reference] and I want to see only unselected values from slicer one in slicer two. I have 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Sample data:

New table:

Table 2 = VALUES('Table'[Reference2])

Measure = 
Var _table=CALCULATETABLE(VALUES('Table'[Reference1]),FILTER('Table',[Reference1]<>BLANK()))
Return
IF(SELECTEDVALUE('Table 2'[Reference2]) in _table,0,1)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ThxAlot · Accepted solution]

Exclusive Slicer.pbix

One can never imagine how weired requests on forum can be.

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Sample data:

New table:

Table 2 = VALUES('Table'[Reference2])

Measure = 
Var _table=CALCULATETABLE(VALUES('Table'[Reference1]),FILTER('Table',[Reference1]<>BLANK()))
Return
IF(SELECTEDVALUE('Table 2'[Reference2]) in _table,0,1)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @Anonymous ,

With jus the information provided, use the below formula as a visual filter = is not blank

=
CALCULATE (
    COUNTA ( 'table'[Other References] ),
    FILTER (
        'table',
        NOT 'table'[Other References] IN VALUES ( 'table'[Promocode References] )
    )
)

Please take note that a previously selected item that is no longer visible because of the change in slicer 1 selection will still be visible in slicer 2  unless deselected. Deselection of non-visible items is not automatic.

[Anonymous]

Hi @danextian , I am getting nothing(no values) when I applied visual level filter = is not blank