- Firstly, you can name them whatever you want, thereby making them more identifiable<\/li>
- Secondly, you can use them as arguments in other DAX expressions<\/li>
- Lastly, you can make them perform complex calculations quickly.<\/li><\/ul>\n\n\n\n
Methods to create a quick measure <\/strong><\/h4>\n\n\n\n
- First – From a table in the\u00a0Fields<\/strong>\u00a0pane, right-click or select\u00a0More options<\/strong>\u00a0(…<\/strong>), and then select\u00a0New quick measure<\/strong>\u00a0from the list.<\/li>
- Second – Under\u00a0Calculations<\/strong>\u00a0in the\u00a0Home<\/strong>\u00a0tab of the Power BI Desktop ribbon, select\u00a0New Quick Measure<\/strong>.<\/li><\/ul>\n\n\n\n
Steps to create a measure<\/strong><\/h4>\n\n\n\n
- Firstly, in the\u00a0Fields<\/strong>\u00a0pane, right-click the\u00a0Sales<\/strong>\u00a0table, or hover over the table and select\u00a0More options<\/strong>\u00a0(…<\/strong>).<\/li>
- In the second step, from the menu that appears, select\u00a0New measure<\/strong>.This action saves your new measure in the\u00a0Sales<\/strong>\u00a0table, where it’s easy to find.<\/li>
- Then, the formula bar appears along the top of the report canvas, where you can rename your measure and enter a DAX formula.<\/li>
- However, by default, each new measure is named\u00a0Measure<\/em>. But if you don\u2019t rename it, additional new measures are named\u00a0Measure 2<\/em>,\u00a0Measure 3<\/em>, and so on. since we want this measure to be more identifiable, highlight\u00a0Measure<\/em>\u00a0in the formula bar, and then change it to\u00a0Net Sales<\/em>.<\/li>
- Now, start by entering your formula. After the equals sign, start to type\u00a0Sum<\/em>. As you type, a drop-down suggestion list appears, showing all the DAX functions, beginning with the letters you type. Scroll down, if necessary, to select\u00a0SUM<\/strong>\u00a0from the list, and then press\u00a0Enter<\/strong>.<\/li>
- Expressions always appear between opening and closing parentheses. For this example, your expression contains a single argument to pass to the SUM function: the\u00a0SalesAmount<\/strong>\u00a0column. Begin typing\u00a0SalesAmount<\/em>\u00a0until\u00a0Sales(SalesAmount)<\/strong>\u00a0is the only value left in the list.<\/li>
- Then, select\u00a0Sales[SalesAmount]<\/strong>\u00a0from the list, and then enter a closing parenthesis.<\/li>
- Press\u00a0Enter<\/strong>\u00a0or select\u00a0Commit<\/strong>\u00a0(checkmark icon) in the formula bar to complete and validate the formula.<\/li>
- Also, if you run out of room for entering a formula or want it on separate lines, select the down arrow on the right side of the formula bar to provide more space.<\/li>
- Lastly, separate parts of your formula by pressing\u00a0Alt<\/strong>\u00a0+\u00a0Enter<\/strong>\u00a0for separate lines, or pressing\u00a0Tab<\/strong>\u00a0to add tab spacing.<\/li><\/ul>\n\n\n\n
Steps to use your measure in the report<\/strong><\/h4>\n\n\n\n
For adding your new\u00a0Net Sales<\/strong>\u00a0measure to the report canvas, and calculate net sales for whatever other fields you add to the report.<\/p>\n\n\n\n
![\"Net](\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/media\/desktop-tutorial-create-measures\/meastut_netsales_byrcn.png\")
Source: Microsoft<\/figcaption><\/figure>\n\n\n\n For observing net sales by country use the following steps –<\/p>\n\n\n\n
- Firstly, select the\u00a0Net Sales<\/strong>\u00a0measure from the\u00a0Sales<\/strong>\u00a0table, or drag it onto the report canvas.<\/li>
- Then, select the\u00a0RegionCountryName<\/strong>\u00a0field from the\u00a0Geography<\/strong>\u00a0table, or drag it onto the\u00a0Net Sales<\/strong>\u00a0chart.<\/li>
- Lastly, to see the difference between net sales and total sales by country, select the\u00a0SalesAmount<\/strong>\u00a0field or drag it onto the chart.<\/li><\/ul>\n\n\n\n
Steps to use your measure with a slicer<\/strong><\/h4>\n\n\n\n
Let us discuss to add a slicer to further filter net sales and sales amounts by calendar year –<\/p>\n\n\n\n
- Firstly, select a blank area next to the chart. In the\u00a0Visualizations<\/strong>\u00a0pane, select the\u00a0Table<\/strong>\u00a0visualization. This action creates a blank table visualization on the report canvas.<\/li>
- Secondly, drag the\u00a0Year<\/strong>\u00a0field from the\u00a0Calendar<\/strong>\u00a0table onto the new blank table visualization. Since Year<\/strong>\u00a0is a numeric field, Power BI Desktop sums up its values. <\/li>
- Then, in the\u00a0Values<\/strong>\u00a0box in the\u00a0Visualizations<\/strong>\u00a0pane, select the down arrow next to\u00a0Year<\/strong>, and then select\u00a0Don’t summarize<\/strong>\u00a0from the list. The table now lists individual years.<\/li>
- Now, select the\u00a0Slicer<\/strong>\u00a0icon in the\u00a0Visualizations<\/strong>\u00a0pane to convert the table to a slicer. If the visualization displays a slider instead of a list, select\u00a0List<\/strong>\u00a0from the down arrow in the slider.<\/li>
- Lastly, select any value in the\u00a0Year<\/strong>\u00a0slicer to filter the\u00a0Net Sales and Sales Amount by RegionCountryName<\/strong>\u00a0chart accordingly. The\u00a0Net Sales<\/strong>\u00a0and\u00a0SalesAmount<\/strong>\u00a0measures recalculate and display results in the context of the selected\u00a0Year<\/strong>\u00a0field.<\/li><\/ul>\n\n\n\n
- Secondly, drag the\u00a0Year<\/strong>\u00a0field from the\u00a0Calendar<\/strong>\u00a0table onto the new blank table visualization. Since Year<\/strong>\u00a0is a numeric field, Power BI Desktop sums up its values. <\/li>
- Then, select the\u00a0RegionCountryName<\/strong>\u00a0field from the\u00a0Geography<\/strong>\u00a0table, or drag it onto the\u00a0Net Sales<\/strong>\u00a0chart.<\/li>
- In the second step, from the menu that appears, select\u00a0New measure<\/strong>.This action saves your new measure in the\u00a0Sales<\/strong>\u00a0table, where it’s easy to find.<\/li>
- Second – Under\u00a0Calculations<\/strong>\u00a0in the\u00a0Home<\/strong>\u00a0tab of the Power BI Desktop ribbon, select\u00a0New Quick Measure<\/strong>.<\/li><\/ul>\n\n\n\n
- First – From a table in the\u00a0Fields<\/strong>\u00a0pane, right-click or select\u00a0More options<\/strong>\u00a0(…<\/strong>), and then select\u00a0New quick measure<\/strong>\u00a0from the list.<\/li>
![\"Microsoft](\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\")
<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"