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
Computing same product sales in DAX
This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards. » Read more
Filtering the Top 3 products for each category in Power BI
This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt the technique to different models and requirements. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/allselected-function-dax