Free PL-300 Exam Braindumps
Microsoft Power BI Data Analyst Questions 141–145 (page: 30)

HOTSPOT (Drag and Drop is not supported)
You have a Power BI semantic model that contains a table named Item. The Item table contains a column named Quantity.
You need to create a DAX query that meets the following requirements:
• The rank of items must be calculated according to the values in Quantity.
• Ranking must NOT be skipped if two or more items have the same value in Quantity.
• If an item is unfiltered, the total of Quantity must display a blank value.
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.

HOTSPOT (Drag and Drop is not supported)
You use Power Query Editor to pull data from a Microsoft SharePoint Online list.
You plan to use Advanced Editor to build a Power Query M formula language query.
You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.

HOTSPOT (Drag and Drop is not supported)
You have a Power BI semantic model that contains two tables as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

You create a Power BI report named Summary1.
You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1.
Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution.
NOTE: Each correct answer is worth one point.

You have a Microsoft 365 subscription that contains the resources shown in the following table.
You create a new dashboard that uses row-level security (RLS) filters. You define a new role named Consultants.
To which resource can you assign the Consultants role?