Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Performs division and returns alternate result or BLANK() on division by 0.
Syntax
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(). |
Return value
- A decimal number.
Remarks
Alternate result on divide by 0 must be a constant.
For best practices when using DIVIDE, see DIVIDE function vs. divide operator (/) in DAX.
Example
The following example returns 2.5.
= DIVIDE(5,2)
Example 1
The following example returns BLANK.
= DIVIDE(5,0)
Example 2
The following example returns 1.
= DIVIDE(5,0,1)