ALL

A table's rows, or columns' values, with every filter on them removed; as a filter of CALCULATE, removes those filters.

Group: Filter. Compatible with DAX.

Syntax

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

Parameter	Type	Description
`table`	Table	A table of the model: all its rows.
`column`	Column repeatable	A column of the model; several columns must come from one table, and give the combinations of their values that occur.

Returns

Table. Every row of the table, or every combination of the columns' values, whatever filters are in place. As a filter of CALCULATE, it removes those filters instead.

Remarks

As a table, it ignores the filter context: in a row for shops only, ALL ( Places[Kind] ) still has both kinds of place.
As a filter of CALCULATE, it takes filters away. ALL ( Products[Product] ) removes only the filter on that column, so a filter on Products[Category] stays; ALL ( Products ) removes every filter on the table. REMOVEFILTERS does the same and says so more plainly.
A table on the many side of relationships takes the filters of the tables it reaches with it: ALL ( Sales ) ignores filters on Products and Places as well.
ALL ( ) with no argument removes every filter in the model. It is allowed only as a filter of CALCULATE or CALCULATETABLE.
When the many side of a relationship holds keys the one side lacks, the one side's table gets an extra blank row for them. ALL includes that row; ALLNOBLANKROW leaves it out.
Columns from two different tables in one call are an error.

Examples

Each product's share of all liters

The filter of each row is removed in the denominator, so it is the same total for every product.

EVALUATE
SUMMARIZECOLUMNS (
    Products[Product],
    "Liters", [Liters sold],
    "Share of all", DIVIDE ( [Liters sold], CALCULATE ( [Liters sold], ALL ( Products ) ) )
)
ORDER BY Products[Product]

Products[Product]	Liters	Share of all
Cider	301074	0.166664913701526
IPA	331884	0.183720341905702
Lettøl	169179	0.0936520703717707
Pils	1004326	0.555962674021001

A table that ignores the filter

EVALUATE
CALCULATETABLE (
    ROW (
        "Kinds in the filter", COUNTROWS ( VALUES ( Places[Kind] ) ),
        "Kinds in all", COUNTROWS ( ALL ( Places[Kind] ) )
    ),
    Places[Kind] = "Shop"
)

Kinds in the filter	Kinds in all
1	2

One column's filter, or the whole table's

Removing the filter on Products[Product] leaves the category's filter in place. ALL of Sales removes the filters of Products too, as Sales reaches Products through its relationship.

EVALUATE
SUMMARIZECOLUMNS (
    Products[Category],
    "Liters", [Liters sold],
    "ALL ( Products[Product] )", CALCULATE ( [Liters sold], ALL ( Products[Product] ) ),
    "ALL ( Sales )", CALCULATE ( [Liters sold], ALL ( Sales ) )
)
ORDER BY Products[Category]

Products[Category]	Liters	ALL ( Products[Product] )	ALL ( Sales )
Beer	1505389	1505389	1806463
Cider	301074	301074	1806463

REMOVEFILTERS, ALLEXCEPT, ALLSELECTED, ALLNOBLANKROW, CALCULATE, VALUES.

Last updated 3 November 2026 · OpenBI Studio 0.3.74

ALL