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
| 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
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 articles
Learn more about ALLNOBLANKROW in the following articles:
-
Avoiding circular dependency errors in DAX
This article explains how DAX handles dependencies between tables, columns and relationships, to help you avoid circular dependency errors. » Read more
-
Blank row in DAX
There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships. » Read more
Related functions
Other related functions are:
Last update: Sep 27, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/allnoblankrow-function-dax