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.
ALLNOBLANKROW(
<table>
)
ALLNOBLANKROW(
<column>
[, <column> [, <column>...]]
)
- table: Name of an existing table.
- column: Columns of an existing table.
The ALLNOBLANKROW function returns a table.
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: