Question 220
A stakeholder needs evidence that the following design achieved its goal: A report needs a reusable Revenue metric that aggregates Sales[NetAmount] under the current slicer context. The design uses Create the measure `Revenue = SUM(Sales[NetAmount])` rather than a stored row-level total column. What is the strongest validation?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Measures evaluate in filter context and should express dynamic aggregations. A failed implementation may show: A calculated column repeating a grand total for each row produces misleading aggregations.
Incorrect Answers
Only closed cases within the selected reporting period are counted. However, this does not establish the required outcome: the revenue card responds to product, date and customer filters with the expected sum.
A customer selection produces one predictable filter path and correct total sales. However, this does not establish the required outcome: the revenue card responds to product, date and customer filters with the expected sum.
Monthly inventory shows one end-of-period value per SKU rather than the sum of all daily stocks. However, this does not establish the required outcome: the revenue card responds to product, date and customer filters with the expected sum.