Question 246
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NOTE: Each correct selection is worth one point.

Question 247
You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

Question 248
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
Question 249
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:
* The count of orders and the sum of total sales by Order Date
* The count of customers who placed an order
* The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

The report will facilitate the following analysis:
* The count of orders and the sum of total sales by Order Date
* The count of customers who placed an order
* The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
Question 250
You have a Power BI data model that contains a table named Employees. The table has the following columns:
* Employee Name
* Email Address
* Start Date
* Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
* Users must see only their own employee data
* The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?

* Employee Name
* Email Address
* Start Date
* Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
* Users must see only their own employee data
* The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?




