Is it possible to verify something like: {"Peter Parker", "Bruce Wayne"} IN DISTINCT(Table[Name])?

[gluizqueiroz]

I have a measure that I need to verify if 2 or more values is in a "selected group", if it is, returns TRUE or FALSE, something like this:

Measure = 
VAR CharactersSelec = DISTINCT(Movies[Name_Characters])
RETURN
SWITCH(TRUE(),
    {"Peter Parker", "Bruce Wayne"} IN CharactersSelec, "Spider and Batman",
    {"Bruce Wayne", "Clark Kent", "Tony Stark"} IN CharactersSelec, "Batman, Superman and Iron",
    BLANK()
)

I will put this measure on a card, but I receive an error saying that: "A table of multiple values was supplied..."

Is there any way to make that verification?

[Zubair_Muhammad · Accepted solution]

@gluizqueiroz 

Try this alternative

Measure = 
VAR CharactersSelec = DISTINCT(Movies[Name_Characters])
RETURN
SWITCH(TRUE(),
    COUNTROWS(EXCEPT({"Peter Parker", "Bruce Wayne"},CharactersSelec))=0, "Spider and Batman",
    COUNTROWS(EXCEPT({"Bruce Wayne", "Clark Kent", "Tony Stark"},CharactersSelec))=0, "Batman, Superman and Iron",
    BLANK()
)

[amitchandak]

@gluizqueiroz ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.