Question 31
You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales.
There is an active relationship between DimDate and FactSales. DimDate is marked as the date table.
FactSales contains the following data.
Model1 contains the following measure:
You have a report that uses Model1. The report has a single report page that has a page level filter set to may
9, 2024. The result of the Previous Year measure is displayed in a card visual.
Which value appear in the card visual?
There is an active relationship between DimDate and FactSales. DimDate is marked as the date table.
FactSales contains the following data.
Model1 contains the following measure:
You have a report that uses Model1. The report has a single report page that has a page level filter set to may
9, 2024. The result of the Previous Year measure is displayed in a card visual.
Which value appear in the card visual?
Question 32
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
Each correct selection is worth one point.
Question 33
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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 have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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.
Question 34
A user creates a Power BI report named ReportA that uses a custom theme.
You create a dashboard named DashboardA.
You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You create a dashboard named DashboardA.
You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 35
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.
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.
