Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 341:

  DRAG DROP

  You need to create a DAX measure in the data model that only allows users to see projections at the appropriate level of granularity.

  How should you complete the measure? To answer, drag the appropriate values to the correct 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.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Scenario: Revenue projections are set at the monthly level and summed to show projections for the quarter. Box 1: IF Box 2: ISFILTERED

  ISFILTERED returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE.

  Box 3: SUM Reference: https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

• Question 342:

  DRAG DROP

  Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  Correct Answer:

  

  Scenario: The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from

  the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

  Define roles and rules in Power BI Desktop

  You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.

  To define security roles, follow these steps.

  1.

  Import data into your Power BI Desktop report, or configure a DirectQuery connection. (step 1: From Power BI Desktop, publish the dataset to powerbi.com)

  2.

  From the Modeling tab, select Manage Roles.

  3.

  From the Manage roles window, select Create.

  (Step 2: From Power BI Desktop, create four roles.)

  4.

  Under Roles, provide a name for the role.

  5.

  Under Tables, select the table to which you want to apply a DAX rule.

  6.

  In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”. (Step 3: From Power BI Desktop, add Table Filter DAX Expression to the roles.)

  7.

  After you've created the DAX expression, select the checkmark above the expression box to validate the expression.

  Step 4: From powerbi.com, add role members to the roles.

  You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

  

  

  8. Select Save.