Press "Enter" to skip to content

Blank and 0 in DAX

Ed Hansberry notes a bit of trickiness with BLANK() in DAX:

It is often the case in Power BI you need to filter your data to include or exclude rows where there are blanks. Be careful though, because you might get unexpected results.

Click through for an example where you might get unexpected results using the BLANK() function.