You 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
• Quantity
Orders 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?

A. Count('Sales'[Order ID])

B. CountA('Sales' [Order ID])

C. CountRows('Sales')

D. DistinctCount('Sales' [Order ID])








 

Suggested Answer: D



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate