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…

QuestionsCategory: PL-300You 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…
Admin Staff asked 7 months ago
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

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.