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.
Remove all filters on the specified table or column applied within the query.
A column in the same base table.
This function removes the corresponding filters from the filter context, restoring the last shadow filter context. It does not materialize the resulting table when called directly in a filter argument of CALCULATE or CALCULATETABLE .
ALLSELECTED can be used as a table expression when it has at least one argument.
ALLSELECTED without arguments can be used only as a CALCULATE or CALCULATETABLE modifier and removes all the filters from the filter context.
ALLSELECTED supports multiple columns as argument since May 2019.
In former versions this syntax is equivalent of ALLSELECTED ( table[column1], table[column2] ):
SUMMARIZE ( ALLSELECTED ( table ), table[column1], tabls[column2] )
Learn more about ALLSELECTED in the following articles:
The definitive guide to ALLSELECTED
ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED. » Read more
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/allselected-function-dax