Forum Discussion

SarveshRealign's avatar
SarveshRealign
New Member
4 years ago
Solved

Show everything else

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 Tra...
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
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity 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