What should you create to meet the reporting requirements of the sales department?

To meet the reporting requirement of counting the total number of sales, a measure is the correct DAX object to create. Measures are designed for aggregations and are calculated dynamically at query time based on the filter context of the report (e.g., slicers, visuals). The COUNTROWS(Sales) function is the most efficient and direct method to count the total number of rows in the 'Sales' table, where each row represents a distinct sales transaction. This approach provides an accurate, context-aware total for reporting visuals.

A. Summing an identifier column (salesid) is a meaningless calculation that does not represent a valid business metric.

B. A calculated column is inefficient for this purpose as it would store the same total count in every row, unnecessarily increasing model size.

D. This option combines two errors: performing a meaningless aggregation (SUM on an ID) and using an inefficient calculated column for a report-level aggregation.

1. Microsoft Learn. (2023). Use DAX in Power BI Desktop. In the "Tutorial: Create your own measures in Power BI Desktop" section

it is explained that measures are used for creating dynamic aggregation calculations. The example for counting order lines uses COUNTROWS('Sales')

directly supporting the chosen answer.

Reference: Module "Model data in Power BI"

Unit "Create DAX calculations in Power BI Desktop"

Section "Tutorial: Create your own measures in Power BI Desktop".

2. Microsoft Docs. (2023). COUNTROWS function (DAX). The official documentation states

"This function counts the number of rows in the specified table

or in a table defined by an expression." This confirms it is the correct function for counting transactions.

Reference: Data Analysis Expressions (DAX) reference

COUNTROWS function documentation.

3. Microsoft Learn. (2023). Calculated columns vs. measures. This documentation explicitly contrasts the two

stating

"Measures are used when you display resulting values in a report... that reflect user selections." This confirms a measure is the correct choice over a calculated column for this reporting scenario.

Reference: Module "Model data in Power BI"

Unit "Introduction to creating DAX calculations in Power BI Desktop"

Section "Calculated columns vs. measures".