DIVIDE DAX Function

The DIVIDE DAX function to achieve division. We must pass in numerator and denominator expressions. Optionally, we can pass in a value that represents an alternate result.

DAX Syntax DIVIDE(, [, ])

The DIVIDE function automatically handles division by zero cases. If an alternate result isn't passed in, and the denominator is zero or BLANK, the function returns BLANK. When an alternate result is passed in, it's returned instead of BLANK.

Example: The following example returns 2.5.

DAX