# 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