Learn how to create your own measures in Power BI Desktop

[bitheerani319]

Put Tutorials
Using measures, you can create some of the most powerful data analysis solutions in Power BI Desktop. Measures help you perform calculations on your data as you interact with reports. This tutorial will guide you through understanding measures and creating your own basic measures in Power BI Desktop.

Prerequisites
This tutorial is intended for Power BI morocco mobile database who are already familiar with using Power BI Desktop to build more advanced models. You should already be familiar with using the Get Data and Power Query Editor features to import data, work with multiple related tables, and add fields to the report canvas. If you're new to Power BI Desktop, be sure to check out Getting started with Power BI Desktop .

This tutorial uses the Contoso Sales Sample file for Power BI Desktop , which includes online sales data for the fictitious company, Contoso. Because this data is imported from a database, you can't connect to the data source to view it in Power Query Editor. Download and extract the file to your computer.

Automatic measurements
When Power BI Desktop creates a measure, it is most often created for you automatically. To see how Power BI Desktop creates a measure, follow these steps:

In Power BI Desktop, select File > Open , navigate to the Contoso Sales Sample for Power BI Desktop.pbix file , and then select Open .

In the Fields pane , expand the Sales table . Then select the check box next to the SalesAmount field , or drag SalesAmount to the report canvas.