DRAG DROP
You have the Power Bl data model shown in the following exhibit.
You create two row-level security (RlS) roles named Manager and CFO.
You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
1. Each manager must see only the data in the Sales and Human Resources tables for their own country.
2. The CFO must be prevented from seeing the data in the Human Resources table.
3. The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the
appropriate expressions to the correct targets. Each expression 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.
The Country table contains the following data.
You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
1. Each manager must see only the data in the Sales and Human Resources tables for their own country.
2. The CFO must be prevented from seeing the data in the Human Resources table.
3. The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.
Drag each option into the matching blank slot.
