Filter visual to NOT show selected value

[graphIt]

Hello Friends,

I have an interesting scenario as a result of COVID-19 I'm trying to see if I can track people that may have come in contact with each other on a bus. The basic setup is a drop down slicer with a list of IDs and a table visual that shows the IDs and bus # for a date range.

The trick that I'm not sure how to do is to filter the visual for what was NOT selected in the slicer. for example

ID    Bus  Day

1      1      1

2      1      1

3      1      1

1      2      2

4      2      2

5      2      2

so lets say in my slicer I select ID 1

The table should then show the following IDs

ID

2

3

4

5

If ID 2 was selected in the slicer then I would see

ID

1

3

Any ideas on how to make this work?

thank you for your help and suggestions.

[parry2k]

@graphIt you should create a separate ID table for slicer which doesn't have relationship with your main table and from there it should be super easy.

[parry2k]

@graphIt solution attached.

[graphIt]

Thank you @parry2k 

the sample you provided doesn't quite solve issue, but it does give me some ideas to try.

It is close though. The idea is, with the sample you provided, if ID 2 was selected in the slicer then it should not show in table visual.

I'll play around with this some more. Thanks for the suggestion.

[parry2k · Accepted solution]

@graphIt that is an easy fix, I was not sure if you want to selected id or not.

Measure = 
VAR __selectedId = SELECTEDVALUE ( Slicer[Id] )
VAR __buses = CALCULATETABLE ( VALUES ( Data[Bus] ), Data[Id] = __selectedId )
RETURN
CALCULATE ( COUNT ( Data[Id] ), __buses, KEEPFILTERS ( Data[Id] <> __selectedId ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[graphIt]

Thank you @parry2k  I did not notice the measure in the visual filter.

Thanks for your help. You, my fried, are a mother #$%%@& rock star!

[parry2k]

😂