DAX Function Reference - Visual Intelligence - page 371

FILTEr FuNCTIoNS

Filter functions, shown in Table B-2, are applied within the Calculate function,
and are used to select from a range of data.

TABle B-2 Filter Functions

FuNCTIoN DESCrIPTIoN

ALL( < table > | < column1 >,
< column2 >,…)

Returns all the rows in a table, or all
the values in a column, ignoring any
filters that might have been applied.

ALLEXCEPT(< table >, < column1 >,
< column2 >,…)

Removes all context filters in the
table except filters that have been
applied to the specified columns.

ALLNOBLANKROW(< table > |
< column >)

From the parent table of a relation-
ship, returns all rows but the blank
row, or all distinct values of a column
but the blank row, and disregards any
context filters that might exist.

ALLSELECTED([< table > |
< column >])

Removes context filters from columns
and rows in the current query, while
retaining all other context filters or
explicit filters.

CALCULATE(< expression >,
< filter1 >, < filter2 >,…)

Evaluates an expression in a context
that is modified by the specified
filters.

CALCULATETABLE(< expression >,
< filter1 >, < filter2 >,…)

Evaluates a table expression in a con-
text modified by filters.

DISTINCT(< column >) Returns a one-column table that

contains the distinct values from the
specified column.

EARLIER(< column >, < number >) Returns the current value of the spec-

ified column in an outer evaluation
pass of the mentioned column.

EARLIEST(< column >) Returns the current value of the

specified column in an outer evalua-
tion pass of the mentioned column.
EARLIEST is similar to EARLIER , but it
lets you specify one additional level
of recursion.

FILTER(< table >, < filter >) Returns a table that represents a sub-

set of another table or expression.

FILTERS(< column >) Returns the values that are directly

applied as filters to column.