DAX Language - ALL Function

A-Badde | Posted on April 08, 20

ALL Function


The ALL function is used for clearing filters and creating calculations on all the rows in a table. It returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.

 Return Value:

ALL returns an entire table or a table with one or more columns.


ALL( [<TableNameOrColumnName> | <ColumnName>[, <ColumnName>[,…]]]] )
  • Description of the parameters:




TableName Or ColumnName

The table or column that you want to clear filters on


Optional column in the same base table. Can be added when the first parameter is a column name



  An example of using the ALL function is to calculate the total amount of sales that ignore all the filters applied on the measure or report.

Total Sales amount = 

The formula above will calculate the total sales amount, and the result will be the same can import the file apply as shown in the following table.


Related Video:



(0) Comments

There is no comment

Leave a Comment
Add to favorite
Recent Posts
DAX Language - CONTAINS Function
A-Badde | May 09, 20

The CONTAINS function returns a boolean value, TRUE if each ...Read More

DAX Language - RANKX Function
A-Badde | May 05, 20

The RANKX function returns a single integer value that repre...Read More

DAX Language - AND and OR Functions
A-Badde | April 10, 20

AND/OR functions check whether all arguments are TRUE or one...Read More

DAX Language - Variables in DAX
A-Badde | April 10, 20

Use Var keyword to store the result of an expression as a na...Read More