The IN operator returns TRUE if a row of values exists or contained in a table, otherwise returns FALSE.
It is syntactic sugar for the CONTAINSROW function, which is used underneath.

Products[Color] IN { "Red", "Black" }

CONTAINSROW (
    { "Red", "Black" },
    Products[Color]
)

Related article: The IN operator in DAX