DP-900 Describe an analytics workload on Azure Practice Question
Exhibit
Refer to the exhibit.
Power BI DAX expression:
```
Total Sales =
CALCULATE(
SUM(Sales[Amount]),
Sales[Channel] = "Online"
)
```Refer to the exhibit. You have a Power BI measure defined as shown. What does this measure return?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The total sales amount for online channel only.
The measure uses CALCULATE to modify the filter context, summing the Amount column only where Channel is 'Online'. Therefore, it returns the total sales amount for the online channel only. Option D is correct. Option A is incorrect because it counts rows, not sums amounts. Option B is incorrect because it sums Amount for each product, not the total. Option C is incorrect because it sums amounts for all channels, not just online.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The count of online sales transactions.
Why it's wrong here
This option mistakes the aggregation method. The measure is based on a numeric SUM of the Amount column, not a count of rows or transactions. To count online transactions, you would need COUNTROWS or DISTINCTCOUNT on a transaction key, but the measure clearly uses SUM, so it returns a monetary total, not a transaction count.
- ✗
The sum of Amount for each product sold online.
Why it's wrong here
This option incorrectly assumes the measure produces a row-level or per-product value. In DAX, a measure is a scalar calculation that returns a single value, and without a GROUPBY or a row context like a product in a visual, SUM(Amount) aggregates across all rows. The CALCULATE filter for Channel='Online' applies to the entire dataset, so the result is one grand total for online sales, not a breakdown per product.
- ✗
The total sales amount for all channels.
Why it's wrong here
This option ignores the explicit filter inside CALCULATE. The Channel='Online' argument modifies the filter context so only rows where Channel equals 'Online' contribute to the SUM(Amount). If all channels were included, there would be no Channel filter and the measure would simply be SUM(Amount), but the filter specifically excludes non-online channels.
- ✓
The total sales amount for online channel only.
Why this is correct
This is correct because CALCULATE evaluates the SUM(Amount) while applying the filter Channel='Online'. This filter context restricts the rows used by SUM to only online transactions, so the measure returns the total sales amount attributed to the online channel. The result is a single scalar, and any external filters in a report are also applied unless overridden.
Go deeper
Related to this question
Learn chapter
Power BI Fundamentals
Key term
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
Key term
Column
A column is a vertical set of values in a database table that stores one specific type of attribute for every row.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.