Home » ALL Function DAX

ALL Function DAX

ALL is a Power BI DAX filter function that returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied.


It removes the corresponding filters from the filter context.

It does not support column expression or table expression.

It returns a table or column with filters removed.

DAX Syntax

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

table  is an existing table that you want to clear filters on.

column is table’s column that you want to clear filters on.

Lets look at an example, Here we have sample dataset having productid and their qunantity as you can see below.

As you can see a table visual showing productId wise their total quantity and the grand total of quantity is 30.

In case if we want to display total quanity regardless productId than we use DAX ALL function.

Following Dax returns total quantity sum ,ignoring filter on product Id .

ALL_Quantity = CALCULATE (

SUM ( TransactionHistory[Quantity] ),

ALL ( TransactionHistory[ProductId])

)

One you drag a ALL_Qunatity measure into table visual, it displays total qunatity against each productId rather than displaying indivdual product id quantity.

It will ignore productId filter as you have taken a productId column in ALL dax function.

As you can see, it does filter the records in table and you can see the total qunatity is now 18 for those selected productId but ALL_Quantity measure still display over all total qunatity sum that is 30 against each productId as ALL function ignoring the filter on productId column.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.