DAX Math & Trigonometric - DIVIDE function

Description

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

Syntax

DIVIDE (<numerator>, <denominator>, [<alternateresult>])

Parameters

Sr.No. Parameter & Description
1

numerator

The dividend or the number to divide.
2

denominator

The divisor or the number to divide by.
3

alternateresult

Optional.

The value returned when division by zero results in an error.

If omitted, the default value is BLANK ().

Return Value

A decimal number or BLANK ().

Remarks

alternateresult on ‘divide by 0’ must be a constant.

Example

= DIVIDE (5,0,"Div by zero Error") returns Div by zero Error. 
= DIVIDE (5,0) returns (blank). 
= DIVIDE (5,4) returns 1.25.
dax_functions_mathematical_trigonometric.htm
Advertisements