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
Please login or Register to submit your answer