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:
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/allselected-function-dax