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

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])

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

Latest DA-100 Dumps Valid Version with 114 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments