![\"Create](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/create-a-measure-in-power-bi.jpg\")
<\/a><\/div>\n<\/a><\/a><\/a><\/div>\nAs part of this process, you may find it necessary to create a measure in Power BI. This measure allows you to represent and visualize the calculated values in a Power BI visual, providing a comprehensive understanding of your sales data.<\/p>\n
Measures are how you represent aggregations in Power BI. Measures tend to be a single value that results from a calculation of a column, for example.<\/p>\n
A total sales measure could be the sum of all the sales amounts in your dataset. It could even be a single column in an Excel sheet or database.<\/p>\n
In this article, we learn all about measures in Power BI. We will begin by defining a measure in Power BI. We will then learn why we create measures in Power BI.<\/p>\n
Table of Contents:<\/h3>\n\n- What is a Measure in Power BI?<\/a><\/li>\n
- Why Create a Measure in Power BI?<\/a><\/li>\n
- Types of Measures in Power BI<\/a><\/li>\n
- How to Create a Measure in Power BI: Step-by-Step<\/a><\/li>\n
- How to use the Measure in the Report?<\/a><\/li>\n
- What are the Common Functions Used in Measure Formulas?<\/a><\/li>\n
- Using Measure In Different Forms<\/a><\/li>\n
- Tips For Creating Measures in Power BI<\/a><\/li>\n
- Wrap Up<\/a><\/li>\n<\/ol>\n
We will then learn how to create a measure in Power BI. Finally, we’ll look at how to analyze measures in Power BI.<\/p>\n
What is a Measure in Power BI?<\/h2>\n
Definition:<\/strong> A measure in Power BI is a calculation or aggregation that processes data in your dataset.<\/p>\nThese computations encompass a wide range of mathematical, statistical, or logical operations, such as<\/p>\n
\n- Aggregations, such as sum, average, count, and minimum\/maximum<\/li>\n
- Ratios and percentages<\/li>\n
- Calculations based on multiple tables<\/li>\n
- Complex calculations using DAX functions<\/li>\n<\/ul>\n
Measures, vital components in Power BI, are created using the Data Analysis Expressions (DAX) language. DAX, a robust tool language, empowers you to seamlessly ‘Create a measure in Power BI’ by facilitating complex calculations on your dataset<\/a>.<\/p>\nMeasures can be utilized to gather data insights, generate metrics, and establish key performance indicators (KPIs)<\/a>.<\/p>\nThis makes them indispensable for creating meaningful and interactive reports and dashboards in Power BI<\/a>.<\/p>\nWhy Create a Measure in Power BI?<\/h2>\n
Measures play a crucial role in data analysis and reporting within the Power BI environment. Creating measures in Power BI is essential for several reasons:<\/p>\n
Summarizing Data<\/h3>\n
Measures provide a way to summarize and aggregate data and give it meaning. This helps in identifying trends and patterns and deriving insights.<\/p>\n
Streamlining the Creation and Maintenance of Reports<\/h3>\n
Using the DAX language, measures can be used to perform complex calculations on your data. These calculations include growth rates and advanced statistical analysis. This streamlines the creation and maintenance of reports.<\/p>\n
Ensuring Consistency<\/h3>\n
Measures allow for reusable formulas across visuals and dashboards. This promotes consistency and minimizes repetitive calculations.<\/p>\n
Combining Data from Multiple Sources<\/h3>\n
Power BI measures enable data integration from diverse sources, simplifying the calculation of desired data. This promotes seamless data analysis<\/a> and integration.<\/p>\nTypes of Measures in Power BI<\/h2>\n
You can create various types of measures in Power BI based on your data and analysis requirements.<\/p>\n
Common types of measures in Power BI include:<\/p>\n
\n- Simple measures<\/strong> – These are basic measures that perform calculations on your data, like sums, counts, and averages. These allow you to quickly get totals and other aggregates.<\/li>\n
- Calculated measures<\/strong> – These are more complex Calculated Measures<\/a>, where you write DAX formulas to define custom calculations. This allows you to create measures that are not available out of the box.<\/li>\n
- Time intelligence measures<\/strong> – these are pre-defined DAX functions for time calculations like year-to-date, rolling averages over time, and year-over-year growth<\/a>. They make time-based analysis easier.<\/li>\n
- Quick measures<\/strong> – these are automatically generated aggregates like sum, count, and average for a selected column. They save time when compared to creating basic measures.<\/li>\n
- Semi-additive measures<\/strong> – These are measures that can be partially summed across dimensions. Useful for things like account balances.<\/li>\n
- Implicit measures<\/strong> – these are created automatically from model relationships. We use DAX variables like SUMX or CALCULATE to dynamically filter results.<\/li>\n
- Automatic measures<\/strong> – these refer to the pre-built or automatically generated measures that Power BI creates for you. They are based on the relationships and data models<\/a> you’ve established in your report.<\/li>\n<\/ul>\n
How to Create a Measure in Power BI: Step-by-Step<\/h2>\n
Consider that you need to evaluate your net sales by deducting discounts and returns from the total sales amount.\u00a0To do this, you need to create a measure that subtracts the sum of DiscountAmount<\/code> and ReturnAmount<\/code> from the sum of SalesAmount<\/code>. Although you don’t see a field labeled “Net Sales” in the Fields list, you can easily build your measure to calculate it.<\/p>\nTo create a measure, follow these steps:<\/p>\n
\n- In the Fields pane, right-click on the Sales table, or hover over the table and select the More options (…) menu.<\/li>\n
- From the dropdown, choose “New measure.”<\/li>\n<\/ol>\n
\n- \n
\n- This action will place your new measure within the Sales table, making it easy to locate.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure1.png\")
<\/a><\/div>\n\n- Another option is to create a measure by selecting ‘New Measure’ from the Calculations group found on the Home tab of the Power BI Desktop ribbon.<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure2.png\")
<\/a><\/div>\n\n- Tip<\/strong>: When creating a measure from the ribbon, you have the flexibility to add it to any table. However, to keep things organized, it’s best to add it to the table where you plan to use it.\n
\n- The formula bar will appear at the top of the report canvas, allowing you to rename your measure and enter a DAX formula.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure3.png\")
<\/a><\/div>\n\n- New measures are automatically named ‘Measure’ by default. If you don’t rename them, additional measures will be labeled ‘Measure 2,’ ‘Measure 3,’ and so on. To make it easily identifiable, highlight “Measure” in the formula bar and change the name to “Net Sales.”<\/li>\n
- Start typing your formula. After the equals sign, begin typing
SUM<\/code>. As you type, a drop-down list of DAX functions will appear, showing all functions starting with the letters you typed. If needed, scroll down to find and select SUM<\/code> from the list, then press Enter.<\/li>\n<\/ol>\n![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure4.png\")
<\/a><\/div>\n\n- \n
\n- An opening parenthesis will appear, along with a list of available columns that can be passed to the
SUM<\/code> function.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure5.png\")
<\/a><\/div>\n\n- Expressions should always be enclosed in parentheses. For this example, your expression will contain one argument for the
SUM<\/code> function: the SalesAmount<\/code> column. Begin typing SalesAmount until Sales[SalesAmount] remains the only option in the list.<\/li>\n<\/ol>\n\n- \n
\n- The column name, along with its table name, is known as the fully qualified name of the column, which makes your formulas easier to understand.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure6.png\")
<\/a><\/div>\n\n- Select
Sales[SalesAmount]<\/code> from the list, then close the parenthesis.<\/li>\n<\/ol>\n\n- \n
\n- Tip<\/strong>: Syntax errors often occur due to missing or misplaced parentheses.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- Subtract the other two columns within the formula:<\/li>\n<\/ol>\n
\n- \n
\n- a. After the closing parenthesis of the first expression, type a space, a minus sign (-), and another space.<\/li>\n
- b. Add another
SUM<\/code> function, then type DiscountAmount<\/code> until you can select Sales[DiscountAmount]<\/code> as the argument. Close the parenthesis.<\/li>\n- c. Type a space, a minus sign, another space, and then another
SUM<\/code> function with Sales[ReturnAmount]<\/code> as the argument. Close the parenthesis.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure7.png\")
<\/a><\/div>\n8. Press Enter or click the Commit button (checkmark icon) in the formula bar to finalize and validate the formula.<\/p>\n
\n- \n
\n- Your validated “Net Sales” measure is now ready for use in the Sales table within the Fields pane.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure8.png\")
<\/a><\/div>\n\n- If you need more space to enter the formula or prefer to split it into separate lines, click the down arrow on the right side of the formula bar.<\/li>\n<\/ol>\n
\n- \n
\n- This will expand the formula bar, providing more room to work.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure9.png\")
<\/a><\/div>\n\n- To separate parts of your formula, press Alt + Enter for a new line, or use the Tab key for indentation.<\/li>\n<\/ol>\n
![\"Measures](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/measure10.png\")
<\/a><\/div>\nHow to use the Measure in the Report?<\/h2>\n
Using the Measure in the report, you can summarize data and display relationships with a Sankey chart<\/a>.<\/p>\nStage 1: Logging in to Power BI<\/h3>\n
You need to install Power BI Desktop if you don’t already have it.<\/p>\n
\n- If you’re using Power BI Desktop for the first time after installation, you need to log in.<\/li>\n
- Enter your email. Click the \u201cSubmit\u201d button.<\/li>\n<\/ul>\n
![\"Enter](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\")
<\/a><\/div>\n\n- Enter your password and click \u201cSign in<\/strong>\u201c.<\/li>\n<\/ul>\n
![\"Enter](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\")
<\/a><\/div>\n\n- Choose whether to stay signed in.<\/li>\n<\/ul>\n
![\"Click](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\")
<\/a><\/div>\nStage 2: Select the Contoso Sales Sample Dataset and Import it to the Power BI Desktop<\/h3>\n\n- We’ll use the Contoso sales sample dataset in the official Microsoft documentation. It’s a fictional dataset with measures that simulate real-world sales data.<\/li>\n
- Download the Contoso dataset and extract the zip file. You should have the dataset as a .pbix file.<\/li>\n
- Log in to Power BI Desktop. You should see the Power BI home page as shown below.<\/li>\n<\/ul>\n
![\"select](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce483.jpg\")
<\/a><\/div>\n\n- Select \u201cFile\u201d and then choose “Open.\u201d<\/li>\n<\/ul>\n
![\"Open](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/Open-file-in-power-bi-ce483.jpg\")
<\/a><\/div>\n\n- Access the Contoso.pbix file from recent files or OneDrive. You can also click “Browse this device” if the file is not on OneDrive or recent files.<\/li>\n
- The data should now be loaded, and you should see some tables under \u201cData\u201d as shown below.<\/li>\n<\/ul>\n
![\"Click](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/click-on-data-loaded-ce483.jpg\")
<\/a><\/div>\n\n- You may see a notification like \u201cOne or more calculated objects need to be manually refreshed.\u201d<\/li>\n
- Click on \u201cRefresh now,\u201d and you should be good to go.<\/li>\n<\/ul>\n
Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo<\/h3>\n
We need to add a Sankey diagram as the visual we’ll use, along with measures.<\/p>\n
\n- Navigate to the Power BI Visualizations panel.<\/li>\n
- Click the ellipsis (…) highlighted below to import the Power BI Sankey Diagram extension by ChartExpo.<\/li>\n<\/ul>\n
![\"Report](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/report-canvas-screen-in-power-bi-ce483.jpg\")
<\/a><\/div>\n\n- Select the \u201cGet more visuals\u201d option.<\/li>\n
- Enter \u201cSankey Diagram for Power BI by ChartExpo\u201d in the highlighted search box.<\/li>\n
- You should see the \u201cSankey Diagram for Power BI by ChartExpo\u201d, as shown in the image below.<\/li>\n<\/ul>\n
![\"Sankey](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/sankey-diagram-for-power-bi-by-chartexpo.jpg\")
<\/a><\/div>\n\n- Click the highlighted \u201cAdd<\/strong>\u201d button.<\/li>\n<\/ul>\n
![\"Click](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-the-add-button.jpg\")
<\/a><\/div>\n\n- Power BI will add the \u201cSankey Diagram for Power BI by ChartExpo<\/strong>\u201d in the visualization panel.<\/li>\n<\/ul>\n
![\"Click](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-sankey-diagram-icon.jpg\")
<\/a><\/div>\nStage 4: Drawing a Sankey Diagram with ChartExpo’s Power BI extension<\/h3>\n\n- Select the \u201cSankey Diagram for Power BI by ChartExpo<\/strong>\u201d icon in the visualization panel.<\/li>\n
- The following window opens in the report section of your dashboard:<\/li>\n<\/ul>\n
![\"Report](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/report-section-in-dashboard-ce483.jpg\")
<\/a><\/div>\n\n\n- You can resize the visual as needed.<\/li>\n
- We can now add some automatic measures to the Sankey diagram.<\/li>\n
- To do this, expand the Sales table under the \u201cFields\u201d pane, as shown below.<\/li>\n<\/ul>\n
![\"Select](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-fields-for-sankey-diagram-ce483.jpg\")
<\/a><\/p>\n<\/div>\n\n- Select the SalesAmount field. This field contains measures that are the total of the sales amounts. Note that all fields in the Sales table are numeric.<\/li>\n
- We also need to select other fields in the Sankey diagram. This will help demonstrate the flow of different values or items.<\/li>\n
- We can select the following additional fields:\n
\n- ClassName (from the Product table)<\/li>\n
- ProductCategory (from the ProductCategory table)<\/li>\n
- StoreType (from the Stores table)<\/li>\n<\/ul>\n<\/li>\n
- Our Sankey chart will be updated as follows:<\/li>\n<\/ul>\n
![\"Create](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/create-a-measure-in-power-bi-1.jpg\")
<\/a><\/div>\n\n- If you don’t have a ChartExpo license key, provide your email address or a ChartExpo license key.<\/li>\n<\/ul>\n
![\"enter](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/11\/enter-email-for-chartexpo-license-ce430.jpg\")
<\/a><\/div>\nStage 5: Activate <\/strong>your ChartExpo Trial or Apply a Subscription Key<\/h3>\n\n- Select the ChartExpo visual.<\/li>\n
- You should see three icons below \u201cBuild Visual<\/strong>\u201d in the Visualizations panel.<\/li>\n<\/ul>\n
![\"Build](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/build-visual-panel-in-power-bi.jpg\")
<\/a><\/div>\n\n- Select the middle icon, \u201cFormat visual<\/strong>\u201c.<\/li>\n
- The visual properties will be populated as shown below.<\/li>\n<\/ul>\n
![\"visual](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/visual-properties-in-power-bi.jpg\")
<\/a><\/div>\n\n- If you are a new user,\n
\n- Type in your email under the section titled \u201cTrial Mode\u201d.<\/li>\n
- This should be the email address that you used to subscribe to the ChartExpo add-in. It is where your ChartExpo license key will be sent.<\/li>\n
- Ensure that your email address is valid.<\/li>\n
- Click \u201cEnable Trial.” You’ll get a 7-day trial.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"enter](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-id.jpg\")
<\/a><\/div>\n\n- \n
\n- You should receive a welcome email from ChartExpo.<\/li>\n
- The Sankey Diagram you create under the 7-day trial contains the ChartExpo watermark.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\n- If you have obtained a license key:\n
\n- Enter your license key in the \u201cChartExpo License Key\u201d textbox in the \u201cLicense Settings\u201d section (see below).<\/li>\n
- Slide the toggle switch next to \u201cEnable License\u201d to “On.”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"enter](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/enter-email-for-chartexpo-license.jpg\")
<\/a><\/div>\n\n\n- To add colors, expand the \u201cLevel Colors\u201d properties and select a color.<\/li>\n
- Do this to change the color of each node.<\/li>\n
- All changes are automatically saved.<\/li>\n<\/ul>\n<\/div>\n
![\"Coloring](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/coloring-sankey-diagram-ce483.jpg\")
<\/a><\/div>\n\n\n- Your final chart should look like the one below. If you get a license, the Sankey Chart will not have a watermark.<\/li>\n<\/ul>\n<\/div>\n
![\"Final](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/final-create-a-measure-in-power-bi.jpg\")
<\/a><\/div>\n![\"\"](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\")
<\/a>![\"\"](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\")
<\/a>![\"\"](\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\")
<\/a><\/div>\nInsights<\/h4>\n
We have used selected fields from the Contoso sales sample dataset. This helps to show the flow of products when using SalesAmount as the measure.<\/p>\n
It’s important to note that the default measure is sum. Our example uses automatic measures. However, you can also create a measure in Power BI that is custom.<\/p>\n
\n- At level 1, ClassName, the category with the most sales was Regular (62.04%). Deluxe came in second at 23.74%. The economy had the fewest sales at 14.49%.<\/li>\n
- At level 2, ProductCategory, computers were the category with the most sold items at 38%. Cameras and camcorders came in second at 31%. TV and Video was third at 16%.<\/li>\n
- At level 3, StoreType, most sales were made at the store (58.20%). Online sales came in second at 20.21%. Reseller sales were third at 13.24%. Catalog sales were the fewest, at 8.34%.<\/li>\n<\/ul>\n
What are the Common Functions Used in Measure Formulas?<\/h2>\n
We will then learn how to create a measure in Power BI. Finally, we’ll look at how to analyze measures in Power BI.<\/p>\n
What is a Measure in Power BI?<\/h2>\n
Definition:<\/strong> A measure in Power BI is a calculation or aggregation that processes data in your dataset.<\/p>\n These computations encompass a wide range of mathematical, statistical, or logical operations, such as<\/p>\n Measures, vital components in Power BI, are created using the Data Analysis Expressions (DAX) language. DAX, a robust tool language, empowers you to seamlessly ‘Create a measure in Power BI’ by facilitating complex calculations on your dataset<\/a>.<\/p>\n Measures can be utilized to gather data insights, generate metrics, and establish key performance indicators (KPIs)<\/a>.<\/p>\n This makes them indispensable for creating meaningful and interactive reports and dashboards in Power BI<\/a>.<\/p>\n Measures play a crucial role in data analysis and reporting within the Power BI environment. Creating measures in Power BI is essential for several reasons:<\/p>\n Measures provide a way to summarize and aggregate data and give it meaning. This helps in identifying trends and patterns and deriving insights.<\/p>\n Using the DAX language, measures can be used to perform complex calculations on your data. These calculations include growth rates and advanced statistical analysis. This streamlines the creation and maintenance of reports.<\/p>\n Measures allow for reusable formulas across visuals and dashboards. This promotes consistency and minimizes repetitive calculations.<\/p>\n Power BI measures enable data integration from diverse sources, simplifying the calculation of desired data. This promotes seamless data analysis<\/a> and integration.<\/p>\n You can create various types of measures in Power BI based on your data and analysis requirements.<\/p>\n Common types of measures in Power BI include:<\/p>\n Consider that you need to evaluate your net sales by deducting discounts and returns from the total sales amount.\u00a0To do this, you need to create a measure that subtracts the sum of To create a measure, follow these steps:<\/p>\n 8. Press Enter or click the Commit button (checkmark icon) in the formula bar to finalize and validate the formula.<\/p>\n Using the Measure in the report, you can summarize data and display relationships with a Sankey chart<\/a>.<\/p>\n You need to install Power BI Desktop if you don’t already have it.<\/p>\n We need to add a Sankey diagram as the visual we’ll use, along with measures.<\/p>\n We have used selected fields from the Contoso sales sample dataset. This helps to show the flow of products when using SalesAmount as the measure.<\/p>\n It’s important to note that the default measure is sum. Our example uses automatic measures. However, you can also create a measure in Power BI that is custom.<\/p>\n\n
Why Create a Measure in Power BI?<\/h2>\n
Summarizing Data<\/h3>\n
Streamlining the Creation and Maintenance of Reports<\/h3>\n
Ensuring Consistency<\/h3>\n
Combining Data from Multiple Sources<\/h3>\n
Types of Measures in Power BI<\/h2>\n
\n
How to Create a Measure in Power BI: Step-by-Step<\/h2>\n
DiscountAmount<\/code> and ReturnAmount<\/code> from the sum of SalesAmount<\/code>. Although you don’t see a field labeled “Net Sales” in the Fields list, you can easily build your measure to calculate it.<\/p>\n\n
\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
\n
<\/a><\/div>\n\n
SUM<\/code>. As you type, a drop-down list of DAX functions will appear, showing all functions starting with the letters you typed. If needed, scroll down to find and select SUM<\/code> from the list, then press Enter.<\/li>\n<\/ol>\n<\/a><\/div>\n\n
\n
SUM<\/code> function.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/a><\/div>\n\n
SUM<\/code> function: the SalesAmount<\/code> column. Begin typing SalesAmount until Sales[SalesAmount] remains the only option in the list.<\/li>\n<\/ol>\n\n
\n
<\/a><\/div>\n\n
Sales[SalesAmount]<\/code> from the list, then close the parenthesis.<\/li>\n<\/ol>\n\n
\n
\n
\n
\n
SUM<\/code> function, then type DiscountAmount<\/code> until you can select Sales[DiscountAmount]<\/code> as the argument. Close the parenthesis.<\/li>\nSUM<\/code> function with Sales[ReturnAmount]<\/code> as the argument. Close the parenthesis.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/a><\/div>\n\n
\n
<\/a><\/div>\n\n
\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\nHow to use the Measure in the Report?<\/h2>\n
Stage 1: Logging in to Power BI<\/h3>\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
<\/a><\/div>\nStage 2: Select the Contoso Sales Sample Dataset and Import it to the Power BI Desktop<\/h3>\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo<\/h3>\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
<\/a><\/div>\nStage 4: Drawing a Sankey Diagram with ChartExpo’s Power BI extension<\/h3>\n
\n
<\/a><\/div>\n\n
<\/a><\/p>\n<\/div>\n\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\nStage 5: Activate <\/strong>your ChartExpo Trial or Apply a Subscription Key<\/h3>\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
\n
<\/a><\/div>\n\n
\n
\n
\n
<\/a><\/div>\n\n
<\/a><\/div>\n\n
<\/a><\/div>\n<\/a><\/a><\/a><\/div>\nInsights<\/h4>\n
\n
What are the Common Functions Used in Measure Formulas?<\/h2>\n