ALLNOBLANKROW DAX Function (Filter)

Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied.

Syntax

ALLNOBLANKROW ( <TableNameOrColumnName> [, <ColumnName> [, <ColumnName> [, … ] ] ] )

Parameter	Attributes	Description
TableNameOrColumnName		The name of an existing table or column.
ColumnName	Optional Repeatable	A column in the same base table. The column can be specified in optional parameters only when a column is used in the first argument, too.

Return values

Table An entire table or a table with one or more columns.

Remarks

This function removes the corresponding filters from the filter context. It does not materialize the resulting table when called directly in a filter argument of CALCULATE or CALCULATETABLE.

Examples

The ALLNOBLANKROW function can be applied to either a table or a set of columns.

ALLNOBLANKROW ( Customer )

ALLNOBLANKROW ( Customer[Country], Customer[State] , Customer[City] )

Related functions

Other related functions are:

Last update: Feb 6, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Jes Hansen

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/allnoblankrow-function-dax