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 …