ALL Function (DAX)

How does the ALL function (DAX) work?

The ALL function (DAX) returns all the rows in a table, or all the values of a column while ignoring any existing filter that might have been applied.  

ALL Formula Syntax

ALL(
     [<table | <column> [, <column> [, <column>[,…]]]]
)

How do you use the ALL function?

The purpose of this function is to remove the corresponding filter from the filter context and to make calculations on all the rows within a table. 

The argument to the ALL function must be either a reference to a base table or a base column. Table expressions or column expressions cannot be used with the ALL function. 

Related Blog Posts

Related Support Forum Posts

Cumulative Banking Transactions – ALL vs ALLSELECTED within cumulative totals
Alternative to ALLSELECTED to get Grand Total of table variable
ISFILTERED function

Considerations when using the ALL function

The ALL function cannot be used by itself. Instead, it is utilized as an intermediate function to change the results where some other calculation is being performed. For example, you can use ALL to remove all filters everywhere, to remove all filters from a specified table, or to remove all filters from specified columns in a table.   

Related Video Tutorials

Formula examples using the ALL function

=ALL( Customer[Country], Customer[State] , Customer[City] )

= ALL (Customer)

Related DAX Functions

FILTER Function (DAX)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.