Drag and Drop Question
You have a Power BI semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.

The model contains one measure that has the following formula.
Deliveries = COUNTROWS('Fact Deliveries')
You need to create a new measure that counts the number of deliveries based on the destination location.
How should you complete the DAX expression? To answer, drag the appropriate functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
CALCULATE: Changes the filter context to evaluate [Deliveries] under a new relationship.
USERELATIONSHIP: Temporarily activates an inactive relationship between Location[Location ID] and 'Fact Deliveries'[Destination Location ID].
This is commonly used when you have multiple relationships between two tables (e.g., one for origin and one for destination), and you want to explicitly activate the one for destination in a specific measure.

Comment: *

Name: *

Email: *

Verification: *

You have a Power Bl semantic model that contains a table named Opportunity.
The Opportunity table contains a column named Qualification
The Qualification column contains values between 0 and V
You need to build a new measure to score the opportunities on a scale of low, medium, and high.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.
You attempt to refresh the data and receive the following error message.
Expression.Error: The column 'Cost' of the table wasn't found.
What is a possible cause of the error?

• A.The privacy level of the data source does not allow combining the data with other data sources.
• B.The Cost column was renamed in the data source.
• C.The source file was moved to a new location.
• D.The data in the Cost column cannot be converted into the target data type.

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *