HOTSPOT -You need to create a measure that will return the percentage of late orders.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.Hot Area:
You create a Power BI workspace named Workspace1.You publish a semantic model and a report to Workspace1.You need to configure Workspace1 to meet the following requirements:• Provide access to a group named Sales.• Ensure that Sales can invite other users to Workspace1.• Follow the principle of least privilege.Which role should you assign to Sales?
What should you create to meet the reporting requirements of the sales department?
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use?
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:
HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)The data has the following refresh requirements:✑ Customer must be refreshed daily.✑ Date must be refreshed once every three years.✑ Sales must be refreshed in near real time.✑ SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:✑ Minimize the load times of visuals.✑ Ensure that the data is loaded to the model based on the refresh requirements.Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
