ALL DAX function

As it’s name suggests, Returns all the rows in a table, or all the values in a column. ALL function removes the applied filters from the filter context. Its comes under Filter function DAX category.

Syntax:

ALL ({<table> or <column>, [<column>], [<column>] …})

Description:

table - The table that you want to clear filters on.

column - The column that you want to clear filters on.

Download the sample Dataset from below link

• SuperStoreUS-2015.xlxs

Now, we will create measure to using DAX  ALL function and in that measure we will do sum of ‘Sales’ column

ALL_DAX =

CALCULATE(Sum(Orders[Sales]), ALL(Orders[Product Sub-Category]))

We passed ‘Product sub category’ column under ALL function, so in that case whatever filters you apply, it will always returns sum of all ‘Product Sub Category‘ and that is 19,24,337.88 .

As per above filters output screen, we did filter few "Product sub categories" but it ignores the filters and returned sum of total sales.

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.