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…
The correct answer is D. DistinctCount('Sales' [Order ID]). DistinctCount('Sales' [Order ID]): count the distinct order IDs in the Sales table, ensuring that each order is only counted once, even if it has multiple order lines.
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])
How the community answered
(32 responses)- A3% (1)
- B6% (2)
- C13% (4)
- D78% (25)
Explanation
DistinctCount('Sales' [Order ID]): count the distinct order IDs in the Sales table, ensuring that each order is only counted once, even if it has multiple order lines.
Community Discussion
No community discussion yet for this question.