How does the IN function (DAX) work?

IN function (DAX) returns True if the scalar value shows up in at least one row of the input relation.

IN Formula Syntax

IN

The IN operator can be used also with dynamic expressions, and it can compare more than one or column.

As it is often the case in DAX, the IN operator is just syntax sugar for calling another DAX function.

The syntax that follows the IN operator is a table constructor, and each row can have a row constructor when its content has more than one column.

Filtered Sales:=CALCULATE (
        [Internet Total Sales], 'Product'[Color] IN { "Red", "Blue", "Black" }
    )