DAX Function Guide

ALLNOBLANKROW Function (DAX)
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ALLNOBLANKROW Function (DAX) work?
The ALLNOBLANKROW function (DAX) returns all rows in a table or all values in a column except for the blank row, while ignoring any context filters that might have been applied in the parent table of a relationship.
ALLNOBLANKROW Function (DAX) Formula Syntax

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

How do you use the ALLNOBLANKROW Function (DAX)?

The ALLNOBLANKROW has only one parameter which can either be a table or a column in which all context filters have been removed.  

Related Blog Posts

Loading

Considerations when using the ALLNOBLANKROW Function (DAX)?

This function removes the filters from the filter context. It does not materialize the resulting table when called directly in a filter argument of CALCULATE or CALCULATETABLE. 

The ALLNOBLANKROW function only filters the blank row if there are one or more rows in the child table that has non-matching values to the parent column in the relationship. 

Related Video Tutorials

Loading

Formula examples using the ALLNOBLANKROW Function (DAX)

= COUNTROWS(
ALLNOBLANKROW(‘DateTime’)
)

=COUNTROWS(
ALLNOBLANKROW(‘ResellerSales_USD’)
)

ALLNOBLANKROW (
Customer[Country], Customer[State] , Customer[City]
)

Related Courses

Loading