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 

How do you use the IN function?

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

Related Blog Posts

Related Support Forum Posts

IF Function needs a calculation
Multi Criteria, IF and contains
Handling Negative Margin Calculation

Considerations when using the IN function

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.

Related Video Tutorials

Formula examples using the IN function

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

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.