Filter Functions

VALUES

When the input parameter is a column name, returns a one-column table that contains the …

USERELATIONSHIP

Specifies the relationship to be used in a specific calculation as the one that exists …

SUBSTITUTEWITHINDEX

Returns a table which represents a left semijoin of the two tables supplied as arguments. …

SELECTEDVALUE

Returns the value when the context for columnName has been filtered down to one distinct …

REMOVEFILTERS

Clear filters from the specified tables or columns.

RELATEDTABLE

Evaluates a table expression in a context modified by the given filters.

RELATED

Returns a related value from another table.

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.

ISFILTERED

Returns TRUE when columnName is being filtered directly. If there is no filter on the …

ISCROSSFILTERED

Returns TRUE when columnName or another column in the same or related table is being …

HASONEVALUE

Returns TRUE when the context for columnName has been filtered down to one distinct value …

HASONEFILTER

Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns …

FILTERS

Returns the values that are directly applied as filters to columnName.

ADDMISSINGITEMS

Adds combinations of items from multiple columns to a table if they do not already …

EARLIEST

Returns the current value of the specified column in an outer evaluation pass of the …

EARLIER

Returns the current value of the specified column in an outer evaluation pass of the …

DISTINCT (table)

Returns a table by removing duplicate rows from another table or expression.

DISTINCT (column)

Returns a one-column table that contains the distinct values from the specified column. In other …

CROSSFILTER

Specifies the cross-filtering direction to be used in a calculation for a relationship that exists …

CALCULATETABLE

Evaluates a table expression in a context modified by the given filters.

CALCULATE

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

ALLSELECTED

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

ALLNOBLANKROW

From the parent table of a relationship, returns all rows but the blank row, or …

ALLEXCEPT

Removes all context filters in the table except filters that have been applied to the …

ALLCROSSFILTERED

Clear all filters which are applied to a table.

ALL

Returns all the rows in a table, or all the values in a column, ignoring …