The ALLNOBLANKROW function receives as an argument the name of one or more columns, or a table, and returns a table containing the rows of the indicated table, column or columns without including the rows formed by blank values and ignoring the possible filters that could be applied to the table, column or columns.
Syntax
ALLNOBLANKROW(
<table>
)
ALLNOBLANKROW(
<column>
[, <column> [, <column>...]]
)
Parameters
- table: Name of an existing table.
- column: Columns of an existing table.
Returned value
The ALLNOBLANKROW function returns a table.
Examples
If we have in our data model a Products table whose rows we want to count ignoring possible blanks and the filters that may be being applied, we can resort to the following measure:
Nº de filas = COUNTROWS(ALLNOBLANKROW(Products))
which, taken to a card-type display, would show the following image:
Related functions
Category
Filter
