Measure basics › AVERAGE4 / 50

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

EasyFreeAVERAGE

AVERAGE: average order value

Nadia runs an online shop selling everything from electronics to sports gear. To set a free-shipping threshold, she needs the average purchase value per order line in each category. Her report page already has a slicer Status = Selesai (completed), so cancelled orders are left out.

Task

Create the measure Rata-rata Nilai Pesanan (average order value) in the Orders table that averages the Orders[Amount] column.
Visual: category (Product[Category]) × year (Calendar[Year]), with the slicer Orders[Status] = Selesai.

MeasureRata-rata Nilai Pesananin table Orders

Required functionsAVERAGE

Expected result

Loading the expected result…

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

Hint 1
An average in DAX is written like in Excel, except the argument is a column instead of a cell range.
Hint 2
The pattern is AVERAGE ( Table[Column] ). The order value column lives in the Orders table.
Hint 3
The slicer already filters the order status, so you do not need to write a Selesai filter inside the measure.

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

Rata-rata Nilai Pesanan

Rata-rata Nilai Pesanan = AVERAGE ( Orders[Amount] )

Explanation

AVERAGE ( Orders[Amount] ) is the sum of Amount divided by the number of rows where Amount is not blank, computed only over the rows that survive every filter: the category from the visual row, the year from the visual column, and Status = Selesai from the slicer. Rumah Tangga (home goods) has the highest average (about Rp470 thousand) even though it is not the most frequently bought category.
Look at the Total row (about Rp295 thousand): it is not the average of the category numbers but a fresh average over all completed orders. A common mistake is averaging the numbers in the visual by hand, which gives small and large categories the same weight.

Data model: toko· table Orders

Rata-rata Nilai Pesanan =

Loading the DAX editor…

Write the DAX expression, then press Check answer.

Validation result