ALLNOBLANKROW

As ALL, without the blank row a relationship adds for values the other table lacks.

Group: Filter. Compatible with DAX.

Syntax

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

Parameter	Type	Description
`table`	Table	A table of the model: all its rows except the blank row.
`column`	Column repeatable	A column of the model; several must come from one table.

Returns

Table. Every row, or every combination of values, whatever filters are in place, without the blank row a relationship may add.

Remarks

When the many side of a relationship holds keys the one side lacks, those rows belong to an extra blank row of the one side's table, so that their numbers still show somewhere. ALL and VALUES include it; ALLNOBLANKROW and DISTINCT leave it out.
A blank stored in a column is a value like any other and is not removed.
As a filter of CALCULATE, it removes filters just as ALL does; the rows that belong to the blank row are counted too.
Every key of the Example Brewery's relationships is found on the other side, so there it gives the same rows as ALL.

Examples

No blank row in the Brewery

EVALUATE
ROW (
    "ALL", COUNTROWS ( ALL ( Products[Product] ) ),
    "ALLNOBLANKROW", COUNTROWS ( ALLNOBLANKROW ( Products[Product] ) )
)

ALL	ALLNOBLANKROW
4	4

As a filter, it removes filters

EVALUATE
SUMMARIZECOLUMNS (
    Products[Category],
    "Liters", [Liters sold],
    "ALLNOBLANKROW ( Products )", CALCULATE ( [Liters sold], ALLNOBLANKROW ( Products ) )
)
ORDER BY Products[Category]

Products[Category]	Liters	ALLNOBLANKROW ( Products )
Beer	1505389	1806463
Cider	301074	1806463

ALL, DISTINCT, VALUES, REMOVEFILTERS.

Last updated 3 November 2026 · OpenBI Studio 0.3.74