DIVIDE Function (DAX)
Performs division and returns alternate result or BLANK() on division by 0.
DIVIDE(<numerator>, <denominator> [,<alternateresult>])
Parameters
| Term | Definition |
|---|---|
| numerator | The dividend or number to divide. |
| denominator | The divisor or number to divide by. |
| alternateresult | (Optional) The value returned when division by zero results in an error. When not provided, the default value is BLANK(). |
A decimal number.
Alternate result on divide by 0 must be a constant.
The following example returns 2.5.
=DIVIDE(5,2)
The following example returns BLANK.
=DIVIDE(5,0)
The following example returns 1.
=DIVIDE(5,0,1)
Community Additions
ADD
Show: