You have a Power Bl report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. 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.

You have a Power Bl workspace that contains a single-page report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product.
The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point

You have the dashboard shown in the following exhibit.

A.

Create and apply a custom dashboard theme.

B.

Change the colors of the visuals in the report.

C.

Apply the Dark dashboard theme

D.

Upload a snapshot image of the dashboard

You have a Microsoft Excel file on a file server.
You create a Power BI report and import a table from the Excel file.
You publish the report.
You need to ensure that the data refreshes every four hours.
What should you do first?

A.

Upload the Excel file to a Power BI workspace.

B.

Create a subscription to the report.

C.

Deploy an on-premises data gateway.

D.

Edit the data source credentials.

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

A.

From Power Bl Desktop, change the Row-Level Security settings.

B.

From Power Bl Desktop, import a table that contains the HR team members

C.

From powerbi.com.add users to the HR role for the dataset.

D.

From powerbi.com, share the dataset to the HR team members.

You have a BI dataset and a connected report.
You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.
You grant the users the Build permission for dataset
What Should do next?

A.

Change default visual interaction for the report

B.

For the report change the Export data setting to Summarized data, data with current layout and underlying data

C.

For the report, change the Export data setting to None

D.

Certify the dataset used by the report.

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce toad times.
Which two actions will reduce the toad times? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

Remove the rows in Traffic in which Traffic [Referring URL] does not start with "/"

B.

Remove the rows in Posts in which Post [Publish Date] is in the last seven days.

C.

Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

D.

Remove Posts [Full Text] and Posts [Summary].

E.

Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

A.

Sync the slicers on Page1 and Page3

B.

On each page, modify the interactions of the slicer.

C.

Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.

You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?

A.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

B.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

C.

Sync the Country slicer on page 1, page 2, and page 3,

D.

Move the Country slicer from page 2 and page 3 to page 1.