Question 342 of 388
Single answerYou have a Power BI model that contains a table named Sales. The Sales table contains the following columns: - Order Line ID- Product ID- Unit Price- Order ID- QuantityOrders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.You need to write a DAX measure that counts the number of orders.Which formula should you use?
ACount('Sales'[Order ID])
BCountA('Sales' [Order ID])
CCountRows('Sales')
✓DDistinctCount('Sales' [Order ID])
✓
Correct Answer: D
DistinctCount('Sales' [Order ID])
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.