Measure basics › DIVIDE5 / 50

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeDIVIDE

DIVIDE: a measure built from other measures

Fajar, an analyst at the coffee chain's head office, already has two measures: [Total Sales] and [Transactions]. He wants to see in which city and through which channel customers spend the most per transaction.

Task

Create the measure Nilai per Transaksi (value per transaction) in the Sales table: [Total Sales] divided by [Transactions] using DIVIDE. Use both existing measures; do not rewrite SUM or COUNTROWS.
Visual: city (Store[City]) × channel (Sales[Channel]).

MeasureNilai per Transaksiin table Sales

Required functionsDIVIDE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
A measure can use other measures. Just write the name inside square brackets, for example [Total Sales].
Hint 2
DIVIDE ( numerator, denominator ) is safer than the / operator: when the denominator is 0 or blank, the result is BLANK instead of an error.
Hint 3
The numerator is total sales, the denominator is the transaction count: DIVIDE ( [Total Sales], ___ ).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

Nilai per Transaksi

Nilai per Transaksi = DIVIDE ( [Total Sales], [Transactions] )

Explanation

DIVIDE ( [Total Sales], [Transactions] ) evaluates both measures in the same cell filter context (city + channel), then divides them. Overall, Online has the highest value per transaction (about Rp49,600) because online customers tend to order more than one item, but not in every city: in Medan, Take-away is the highest.
Building measures from other measures means the business logic is written once. If the definition of [Total Sales] changes (say, excluding corporate orders), every derived measure stays correct. The / operator gives the same numbers here, but with a zero denominator it returns Infinity or NaN, while DIVIDE returns BLANK (or the alternate value in its third argument).

Data model: kopi· table Sales

Nilai per Transaksi =

Loading the DAX editor…

Write the DAX expression, then press Check answer.

Validation result