Notifications
Clear all
Topic starter
08/11/2022 11:38 pm
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])
Suggested Answer: C
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.
Reference: https://docs.microsoft.com/en-us/dax/countrows-function-dax
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.
Reference: https://docs.microsoft.com/en-us/dax/countrows-function-dax