DAX Function Guide

IN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the IN 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?

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

Related Blog Posts

Loading

Considerations when using the IN?

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

Loading

Formula examples using the IN
Filtered Sales:=CALCULATE (
[Internet Total Sales], 'Product'[Color] IN { "Red", "Blue", "Black" }
)
Related Courses

Loading