DIVIDE for safe division in Power BI - Step-by-Step Guide

Introduction

DIVIDE helps you divide numbers safely in Power BI. It avoids errors when the bottom number is zero or missing. This keeps your reports clean and error-free.

When you want to calculate ratios like profit margin but some sales values might be zero.

When dividing total sales by number of customers and some customers count is zero or blank.

When creating a measure that divides two columns and you want to avoid showing errors.

When you want to show a default value instead of an error if division is not possible.

When you want your dashboard to look professional without error messages in visuals.

Steps

Step 1: Open

- Power BI Desktop

Your report and data model are visible

Step 2: Click

- Modeling tab

Modeling ribbon options appear

Step 3: Click

- New measure button

Formula bar opens for writing a new measure

Step 4: Type

- Formula bar

Measure formula is ready to use

💡 Use syntax: DIVIDE(numerator, denominator, alternateResult)

Step 5: Enter

- Formula bar

Measure is created and appears in Fields pane

💡 Example: DIVIDE(SUM(Sales[Profit]), SUM(Sales[Revenue]), 0)

Step 6: Add

- Report canvas

Visual shows the safe division result without errors

Before vs After

Before

Measure using simple division: SUM(Sales[Profit]) / SUM(Sales[Revenue]) shows error when Revenue is zero or blank

After

Measure using DIVIDE: DIVIDE(SUM(Sales[Profit]), SUM(Sales[Revenue]), 0) shows 0 instead of error when Revenue is zero or blank

Settings Reference

Numerator

📍 DIVIDE function argument

The top number in the division

Default: None

Denominator

📍 DIVIDE function argument

The bottom number in the division

Default: None

Alternate result

📍 DIVIDE function argument

Value to show instead of error when division is not possible

Default: Blank (shows blank result)

Common Mistakes

Using simple division operator (/) without checking denominator

It causes errors or infinite values when denominator is zero or blank

Use DIVIDE function with alternate result to handle zero denominator safely

Not providing alternate result in DIVIDE

DIVIDE returns blank by default which may confuse report viewers

Provide a meaningful alternate result like 0 or "N/A" for clarity

Summary

DIVIDE safely divides numbers and avoids errors from zero or blank denominators.

It lets you specify a value to show when division is not possible.

Use DIVIDE instead of / operator for reliable and clean report calculations.