ALL DAX Function

The ALL function returns a table containing all the rows, or all the values in a column, ignoring any filters that might have been applied (ignores internal visual filter and ignores any external filters also like from slicers). This function is useful for clearing filters and creating calculations on all the rows in a table.

DAX Syntax ALL( [table | column[, column[, column[,…]]]] )

The function has the following parameters:

table: The table that we want to clear filters on.
column: The column that we want to clear filters on.

Note: The argument to the ALL function must be either a reference to a base table or a reference to a base column. We cannot use table expressions or column expressions with the ALL function.

Example 1: Create a measure, in which all the filters applied on the table named “sheet1” is ignored.

DAX

All Sum Measure = CALCULATE(SUM(Sheet1[10th Marks]), ALL(Sheet1))

The formula calculates the sum of the "10th Marks" column from the "Sheet1" table, disregarding any filters applied to the "Sheet1" table within the context of the calculation (even outer filters coming from slicers, for example). This effectively gives us the total sum of all the values in the “10th marks” column of the "Sheet1" table.

Previous Next