Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.
The name of an existing table or column.
A column in the same base table. The column can be specified in optional parameters only when a column is used in the first argument, too.
This function removes the corresponding filters from the filter context, just as REMOVEFILTERS does. It does not materialize the resulting table when called directly in a filter argument of CALCULATE or CALCULATETABLE .
ALL can be used as a table expression when it has at least one argument.
ALL without arguments can be used only as a CALCULATE or CALCULATETABLE modifier and removes all the filters from the filter context.
The following remarks are valid using ALL as a table expression:
- Using a table argument, ALL returns all the rows of the table including any duplicated rows.
- Using a single column argument, ALL returns all the unique values of the column.
- Using two or more columns arguments, ALL returns all the unique combinations of values in multiple columns.
- In every case, ALL includes in the result the additional blank row generated for invalid relationships.
The ALL function can be applied to either a table or a set of columns.
ALL ( Customer ) ALL ( Customer[Country], Customer[State] , Customer[City] )
Learn more about ALL in the following articles:
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
Using ALLEXCEPT versus ALL and VALUES
This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016. » Read more
Context Transition and Expanded Tables
This article describes how table expansion and filter context propagation are important DAX concepts to understand and fix small glitches in DAX expressions. » Read more
Blank row in DAX
There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/all-function-dax