Filter functions

The filter and value functions in DAX are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic calculations.

In this category

Function Description
ALL Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
ALLCROSSFILTERED Clear all filters which are applied to a table.
ALLEXCEPT Removes all context filters in the table except filters that have been applied to the specified columns.
ALLNOBLANKROW From the parent table of a relationship, 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 Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
CALCULATE Evaluates an expression in a modified filter context.
CALCULATETABLE Evaluates a table expression in a modified filter context.
FILTER Returns a table that represents a subset of another table or expression.
KEEPFILTERS Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function.
LOOKUPVALUE Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions.
REMOVEFILTERS Clears filters from the specified tables or columns.
SELECTEDVALUE Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.