DIVIDE DAX Function in Power BI
The DIVIDE function in DAX is a specialized arithmetic function in Power BI designed to perform division operations while providing built-in error handling for division by zero scenarios. In the standard division operator (/), division by 0 throws an error, which gracefully handles by the DIVIDE function. So, DIVIDE function is a safer and more convenient alternative to using the division operator (/) directly.
DAX Syntax DIVIDE(numerator, denominator[, alternate_result])
The function has the following parameters:
- numerator: The number or expression to be divided (the dividend). This can be a literal number, a column, a measure, or a DAX expression that evaluates to a numeric value.
- denominator: The number or expression by which to divide (the divisor). Like the numerator, it can be a literal number, column, measure, or expression.
- alternate_result: It is an optional parameter. The value to return if the division is undefined (e.g., division by zero or BLANK). If omitted, the function returns BLANK() in such cases.
Example: Let’s create a measure with name “Divide value”.
DAX
The output of the above code is 10, as shown in the image below:
Example: Let’s divide by 0.
DAX
The output of the above code is Blank, as shown in the image below:
Example: Let’s specify the Alternate result.
DAX
The output of the above code is 0, as shown in the image below:
