Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain data 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 format
The Order table contains more than one million rows.
The Store table has 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.
End of repeated scenario.
You are modifying the model to report on the number of order.
You need to calculate the number of orders.
What should you do?

• A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
• B. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.
• C. Create a calculated measure that uses the SUM (Order_ID) DAX formula.
• D. Create a calculated column that uses the SUM (Order_ID) DAX formula.

You plan to develop a Power BI report that has a bar chart to display the number of customers by location.
You have a table named Customer that has the following columns:
* Customer ID
* CustomerName
* Address
* City
* ProvState
* Country
You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

• A. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
• B. In the Axis field, add Country at the top, followed by ProvState, and then City.
• C. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
• D. In the Value field, add Country at the top, followed by ProvState, and then City.

You have a Microsoft Excel spreadsheet that contains a table named Sales.
You need to add the Sales table to a Power BI dashboard as a tile.
How should you configure the tile?

• A. From the Power BI service, upload the Excel workbook.
• B. From the Power BI service, import the data from the Excel workbook.
• C. From the Power BI tab in Excel, pin the table.
• D. From Excel, publish the workbook to the Power BI service.

You have a power BI model that contains the following tables:
* Assets( AssetsID, AssetName, Purchase_DateID, Value)
* Date( DateID, Date, Month, Week, Year)
The tables have relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?

• A. (sum(Assets[Value])
  -CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR('Date'[Date])))/CALCULATE(sum(As ('Date' [Date]))
• B. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR ('Date' [Date]))/sum(Assets[Value])
• C. CALCULATEx(sum(Assets[Value]) DATESYTD ('Date'[Date]))/sum(Assets[Value])
• D. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR ('Date' [Date]))