Filter Functions
Filter functions manipulate table and filter contexts.
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 the specified table. |
ALLEXCEPT | Returns all the rows in a table except for those rows that are affected by the specified column filters. |
ALLNOBLANKROW | Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied. |
ALLSELECTED | Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside the query, but keeping filters that come from outside. |
CALCULATE | Evaluates an expression in a context modified by filters. |
CALCULATETABLE | Evaluates a table expression in a context modified by filters. |
FILTER | Returns a table that has been filtered. |
KEEPFILTERS | Changes the CALCULATE and CALCULATETABLE function filtering semantics. |
LOOKUPVALUE | Retrieves a value from a table. |
REMOVEFILTERS | Clear filters from the specified tables or columns. |
SELECTEDVALUE | Returns the value when there's only one value in the specified column, otherwise returns the alternate result. |
Last update: May 18, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo