________ measures are automatic behaviors that allow visuals to summarize model column data.

_______ measures, also known simply as measures, are calculations that you can add to your model.

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

You need to reduce the size of the data model without losing access to any data. What should you do?

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year.

You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

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 build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

You’ve created a report that you published to a workspace. A few  business users need to have the ability to view the reports. What’s the most  appropriate way to achieve this? 

Your solution must consider that the report audience may change in the  future and that you’ve already created other reports in the workspace that  will be ready to be shared at a later date.

What is a key benefit of data analysis?