ALLNOBLANKROW

ALLNOBLANKROW From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row, and disregards any context filters that might exist.


Syntax

ALLNOBLANKROW( {table | column[, column[, column[,…]]]} )

Parameters

Table- The table over which all context filters are removed.

Column – A column over which all context filters are removed.

Return Value

A table, when the passed parameter was a table, or a column of values, when the passed parameter was a column.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Filter Functions / ALLNOBLANKROW