IN

Returns True if the scalar value shows up in at least one row of the input relation.

Syntax

IN 

Parameters

Term Definition
scalar expression
table expression

Return value

Remarks

Example

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

See also