DIVIDE

DIVIDE Performs division and returns alternate result or BLANK() on division by 0.


Syntax

DIVIDE(numerator, denominator [,alternateresult])

Parameters

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.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Math and Trig Functions / DIVIDE