Forum Discussion

SarveshRealign's avatar
SarveshRealign
New Member
4 years ago
Solved

Show everything else

I have the following tables: 

Participants NameTrainings
ATraining-1
ATraining-2
BTraining-2
CTraining-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
Need Help
Show and Tell
Tips and Tricks
  • Anand24's avatar
    Anand24
    4 years ago

    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

2 Replies

  • Anand24's avatar
    Anand24
    Super User
    4 years ago

    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
  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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