DIVIDE for safe division in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to safely divide Total Sales by Total Quantity using DIVIDE.

Power BI

Safe Division = DIVIDE([Total Sales], [1])

Drag options to blanks, or click blank then click option'

A[Total Price]

B[Total Quantity]

C[Quantity Sold]

D[Sales Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column unrelated to quantity as the denominator.

Not using DIVIDE and risking division by zero errors.

The DIVIDE function safely divides Total Sales by Total Quantity, avoiding errors if the denominator is zero or blank.

2fill in blank

medium

Complete the code to divide Revenue by Units Sold safely with DIVIDE and provide 0 as the alternate result.

Power BI

Average Price = DIVIDE([Revenue], [Units Sold], [1])

Drag options to blanks, or click blank then click option'

A1

BBLANK()

C0

DERROR()

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the alternate result blank, which returns BLANK() by default.

Using ERROR() which causes an error instead of handling it gracefully.

Using 0 as the alternate result ensures the measure returns zero instead of an error when dividing by zero or blank.

3fill in blank

hard

Fix the error in the code by replacing the incorrect division operator with DIVIDE.

Power BI

Profit Margin = [1]([Profit], [Revenue])

Drag options to blanks, or click blank then click option'

ADIVIDE

B/

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '/' operator which can cause errors if denominator is zero.

Using multiplication or subtraction operators by mistake.

DIVIDE is used for safe division in DAX to avoid errors when dividing by zero or blank values.

4fill in blank

hard

Fill both blanks to create a measure that divides Total Cost by Total Units and returns "No Data" if denominator is zero.

Power BI

Cost per Unit = DIVIDE([1], [2], "No Data")

Drag options to blanks, or click blank then click option'

A[Total Cost]

B[Total Revenue]

C[Total Units]

D[Units Sold]

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping numerator and denominator.

Using unrelated columns causing wrong calculations.

The measure divides Total Cost by Total Units safely and returns the text "No Data" if Total Units is zero or blank.

5fill in blank

hard

Fill all three blanks to create a measure that divides Total Profit by Total Sales, returns 0 if denominator is zero, and formats the result as a percentage.

Power BI

Profit Percentage = FORMAT(DIVIDE([1], [2], [3]), "0.00%")

Drag options to blanks, or click blank then click option'

A[Total Profit]

B[Total Sales]

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 as alternate result which inflates the percentage.

Not formatting the result as a percentage.

This measure safely divides Total Profit by Total Sales, returns 0 if sales is zero, and formats the result as a percentage with two decimals.