ALLNOBLANKROW DAX Function (Filter)

Zwraca wszystkie wiersze oprócz pustych wierszy w tabeli lub wszystkie wartości w kolumnie i ignoruje wszelkie zastosowane filtry.

Syntax

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

Parameter	Attributes	Description
TableNameOrColumnName		Nazwa istniejącej tabeli lub kolumny.
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: Dec 14, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/allnoblankrow-function-dax