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

Useful Video Courses

Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours