Home » Microsoft » DA-100 v.2 » Case Study
What should you create to meet the reporting requirements of the sales department?
A. a measure that uses a formula of SUM(Sales[sales_id])
B. a calculated column that use a formula of COUNTA(Sales[sales_id])
C. a measure that uses a formula of COUNTROWS(Sales)
D. a calculated column that uses a formula of SUM(Sales[sales_id])
Correct Answer: C
Explanation/Reference:
Explanation:
The sale department requires reports that contain the number of sales transactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
Incorrect Answers:
B: COUNTA counts the number of values in a column. It returns the number of cells in a column that contain a non blank value.
Reference:
https://docs.microsoft.com/en-us/dax/countrows-function-dax