Excel DAX - Special Values

The following table lists some DAX special values.

Sr.No	Special Value & Description
1	BLANK A null, or a blank value, or an empty cell, or a missing value.
2	Infinity Infinity value, as considered in mathematics (∞). DAX returns Infinity, if there is a division by zero.
3	NaN Not a Number. DAX returns NaN for 0/0 and Infinity/Infinity.

Sr.No

Special Value & Description

BLANK

A null, or a blank value, or an empty cell, or a missing value.

Infinity

Infinity value, as considered in mathematics (∞).

DAX returns Infinity, if there is a division by zero.

NaN

Not a Number.

DAX returns NaN for 0/0 and Infinity/Infinity.

If you divide an expression by Infinity, you will not get an error, as DAX returns 0.

excel_dax_syntax.htm