DIVIDE - Daxplained

DIVIDE is a DAX function that safely divides two numbers and handles cases where the denominator is zero.

Syntax

DIVIDE(
   Numerator,
   Denominator,
   AlternateResult
)

Argument	Properties	Description
Numerator		Numerator.
Denominator		Denominator.
AlternateResult	Optional	Optional. The alternate result to return when dividing by zero.

Alternate result on divide by 0 must be a constant.
For best practices when using DIVIDE, see DIVIDE function vs. divide operator (/) in DAX.

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)

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/divide-function-dax