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