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: Sep 28, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
2018-2022 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies