Show everything else

[SarveshRealign]

I have the following tables: 

Participants Name	Trainings
A	Training-1
A	Training-2
B	Training-2
C	Training-3

List of All Trainings

Training-1

Training-2

Training-3

Training-4

Training-5

I want to create a visual: when I select Participants A, I want to see all the Trainings he has not participated instead of seeing the Trainings he particpated.
When I click A, I want to see something like this:

Trainings Not Participated

Training-3

Training-4

Training-5

[v-easonf-msft]

Hi, @SarveshRealign 

Create a measure as below, and apply it to 'filters on this visual'. (Note that there is no need to establish a relationship between these two tables)

flag =
IF (
    NOT (
        SELECTEDVALUE ( Table2[List of All Trainings] ) IN VALUES ( Table1[Trainings] )
    ),
    1,
    0
)

Please check my sample for more details.

Best Regards,
Community Support Team _ Eason

[Anand24 · Accepted solution]

Hi @SarveshRealign ,

Go through this ~5.5 Min video and you should be able to achieve your functionality of excluding selections. 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn