☎  076 959 6407✉  support@quizcrazepro.co.za
Learn. Practice. Build your future.
BlogHelpContact

PL-300 Microsoft Power BI Data Analyst Exam Actual Questions

388 Questions120 Minutes70% Passing Score▣ Updated: Sep 2026

Question 73 of 388

Single answer
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.You have a Microsoft SQL Server database that contains the following tables. The following columns contain date information: - Date[Month] in the mmyyyy format- Date[Date_ID] in the ddmmyyyy format- Date[Date_name] in the mm/dd/yyyy format- Monthly_returns[Month_ID] in the mmyyyy formatThe Order table contains more than one million rows.The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.You plan to use Power BI Desktop to create an analytics solution for the data.You are modifying the model to report on the number of orders.You need to calculate the number of orders.What should you do?
ACreate a calculated measure that uses the COUNTA(Order_ID) DAX formula.
BCreate a calculated column that uses the COUNTA(Order_ID) DAX formula.
CCreate a calculated column that uses the SUM(Order_ID) DAX formula.
DCreate a calculated measure that uses the SUM(Order_ID) DAX formula.
Correct Answer: A

Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.

Explanation

The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.

About this practice exam

Review 388 Microsoft questions with answers and explanations. Use the navigation to move through the exam at your own pace.