PL-300 · Question #342
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 identif
Sign in or unlock PL-300 to reveal the answer and full explanation for question #342. The question stem and answer options stay visible for context.
Question
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?
Options
- ACount('Sales'[Order ID])
- BCountA('Sales' [Order ID])
- CCountRows('Sales')
- DDistinctCount('Sales' [Order ID])
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.