Question 316

You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value 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.

Question 317

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.
You add the following fields to the Explain By field:
* Customer Country
* Product Category
* Supplier Country
* Sales Employee
* Supplier Name
* Product Name
* Customer City
The key influencers visual returns the results shown in the following exhibit.
What can you identify from the visual?
  • Question 318

    You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
    Which role should you assign to the user?
  • Question 319

    You have the Power Bl model shown in the following exhibit.

    There are four departments in the Departments table.
    You need to ensure that users can see the data of their respective department only.
    What should you do?
  • Question 320

    -
    You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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.