Article

DAX Language - ALL Function


A-Badde | Posted on April 08, 20

ALL Function

 Description:

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.

 Syntax:

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

 

PARAMETER

DESCRIPTION

TableName Or ColumnName

The table or column that you want to clear filters on

ColumnName

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

 

 Example:

  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 = 
            SUMX(
                ALL(Sales),
                Sales[SalesAmount]
                )

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

Your email address will not be published. Required fields are marked *

Add to favorite
Categories
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