{"id":24313,"date":"2018-08-16T09:30:43","date_gmt":"2018-08-16T09:30:43","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=24313"},"modified":"2019-06-14T18:06:32","modified_gmt":"2019-06-14T12:36:32","slug":"measures-in-power-bi","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/","title":{"rendered":"Creating and Using Measures in Power BI – A Complete Learning!"},"content":{"rendered":"

In this tutorial, we are going to learn about measures in Power BI. Dealing with a huge set of data coming in from different data sources can be challenging and demanding. While most of the business intelligence tools come loaded with all sorts of functionalities for data extraction, preparation, transformation, visualization, and reporting, <\/em>there might be some areas where you need a little extra. Measures are those extras in Power BI which strengthens reporting capabilities even more.<\/p>\n

So, let’s get started with our tutorial on measures in Power BI and learn how to use them.<\/p>\n

Measures in Power BI<\/h2>\n

Power BI desktop offers a wide range of functionalities to create reports and insights into data easily. But still, there might be some areas or points in a report where you feel that you cannot represent what you want with the data that you have. For such cases, you can create your own measures in Power BI. Measures enable creating advanced solutions and models in Power BI for data analysis and reporting. So, measures perform real-time calculations based on your interactions with data on your report.<\/p>\n

Usually, measures are used in aggregation calculations such as sum, average, minimum value, maximum value, counts or more advanced level calculations<\/em> made using DAX formula<\/strong>. So, in other words, measures are like formulas that are calculated. Then it produces a result specific to the purpose and values it is used for.<\/p>\n

The values that measure yield are not saved in RAM storage because measures are used relatively and may have different values when used in different scenarios and contexts.<\/p>\n

You can create new measure fields for your analysis easily in Power BI desktop. In the sections to follow, we will learn how to create a measure in Power BI desktop.<\/p>\n

Wait!! Have you checked the Power BI Desktop Tutorial<\/a><\/strong><\/em><\/p>\n

Prerequisites to Working on Measures in Power BI<\/h4>\n

The first and most basic prerequisite for you to be able to create and work with measures is that you must be familiar with Power BI desktop. You must know some basic operations such as importing data using Get Data and Query Editor, creating data models, formatting fields, working with multiple associated tables, and creating a report<\/em>. If you are well versed with working on Power BI desktop, you can easily work with measures to create more complex data analysis reports.<\/p>\n

Download this sample data report,\u00a0Contoso sales sample<\/a> for Power BI Desktop to understand measures better. Work with us using this dataset and report on Power BI Desktop. We will learn how to create a measure in Power BI from the fields given in this sample Power BI report.<\/p>\n

Creating and Using a Measure in Power BI<\/h3>\n

Usually, whenever you import a field from a dataset and use it in a visualization in Power BI desktop, the software automatically calculates the values according to selected aggregation type. But if that is not enough, you can always create your own measure. Measures in Power BI are used for advanced calculations as they evaluate\u00a0Data Analysis Expressions (DAX)<\/strong> to give out the results from complex queries. Power BI desktop offers a library having about 200 DAX functions<\/em> to perform complex calculations. In this section, we\u2019ll see how to create measures in Power BI desktop.<\/p>\n

Follow the steps given below –<\/p>\n

Open Power BI Desktop on your system. Then select the sample dataset whose link we have provided in the prerequisite section.<\/p>\n

\"open<\/a><\/p>\n

1. How to Create a Measure<\/h4>\n

Before we start creating a new measure, let\u2019s assume a scenario here. Suppose, you are the sales manager of Contoso Pvt. Ltd. And, you are asked to submit a report on projected sales for the year 2019. Now, the right way to do this is to base your projection or sales estimates on the previous year\u2019s sales i.e. 2018. Then, we\u2019ll add the expected increase in percentage because of the promotions and offers and then generate the sales amount for 2019. We will make the new sales amount using measures.<\/p>\n

Step 1:<\/strong> Once you open the Contoso sales sample file in Power BI Desktop, you will find all the data fields and tables available in it.<\/p>\n

\"field<\/a><\/p>\n

Step 2:\u00a0<\/strong>The first thing we\u2019ll do is rename the field SalesAmount<\/strong> to TotalSales2018<\/strong> as it is the sales of the previous year.<\/p>\n

\"right-click<\/a><\/p>\n

Step 3:\u00a0<\/strong>To do this, right-click on the field name and select the\u00a0Rename<\/strong> option and enter the new name.<\/p>\n

\"rename<\/a><\/p>\n

Step 4:\u00a0<\/strong>Next, we\u2019ll create a new field using New measure<\/strong> option. You can do this in two ways; by right-clicking on the table\u2019s name in which you wish to add the measure field and selecting New measure<\/strong>.<\/p>\n

\"right-click<\/a><\/p>\n

Or, by going to the Modeling<\/strong> tab and clicking on New measure<\/strong> option.<\/p>\n

\"go<\/a><\/p>\n

Explore the Types of Filters in Power BI<\/a><\/strong><\/em><\/p>\n

Step 5:<\/strong> In the formula bar, start with entering the name of your new measure. In the supposed scenario, we are using the name ProjectedSales2019. After this, add other elements and make an expression.<\/p>\n

\"enter<\/a><\/p>\n

Step 6:<\/strong> Our expression of Projected sales for 2019 is shown in the image below. We have multiplied the sum of previous year\u2019s sales by 1.08 because an increase in sales by 8% is expected in the year 2019.<\/p>\n

\"measure<\/a><\/p>\n

Step 7:<\/strong> Save this and your newly created measure will appear in the Fields<\/strong> column under the table Sales. Every measure field created like this has a calculator icon beside it.<\/p>\n

\"new<\/a><\/p>\n

Step 8:<\/strong> You can immediately use new measure in a simple visual comparing the total sales of 2018 and projected sales of 2019.<\/p>\n

\"measure<\/a><\/p>\n

2. Using Measure in a Report<\/h4>\n

Once that you have created a measure, you can use it in many ways in your Power BI report. In the scenario of Contoso Pvt. Ltd., you can use the new measure field, Project Sales 2019 in all the visuals available in Power BI desktop. For instance, we have used the new measure field to create a bar chart showing total sales for 2018 and
\nprojected sales for 2019 in every country.<\/p>\n

\"measure<\/a><\/p>\n

Similarly, you can create a complete report page showing details of projected sales in 2019 as shown in the screenshot below. The pie chart also uses the new measure along with product categories to visually represent category wise projected sales for 2019.<\/p>\n

\"measure<\/a><\/p>\n

Explore the complete tutorial on Power BI Report Server<\/a><\/strong><\/em><\/p>\n

3. Using Measure with a Slicer<\/h4>\n

You can also use a slicer along with visuals using newly created measure fields. The measure fields promptly respond to any selection made in a slicer.<\/p>\n

Step 1:<\/strong> To add a slicer, select on the Slicer<\/strong> icon from the Visualizations<\/em> section.<\/p>\n

\"select<\/a><\/p>\n

Step 2:\u00a0<\/strong>Then, add a field to populate the slicer with values.<\/p>\n

Step 3:\u00a0<\/strong>A raw form of the slicer will appear on your report canvas. Format it accordingly. The slicer made by us is highlighted in the red box. It contains the names of the manufacturers involved.<\/p>\n

\"place<\/a><\/p>\n

Step 4:<\/strong> Make a selection on the slicer and all the other visuals will change the displayed information accordingly. Look at the screenshot below where we selected the manufacturer Fabrikam Inc. The pie chart, bar chart, and card will show information on projected sales 2019 only for this company.<\/p>\n

\"using<\/a><\/p>\n

Do you know – What is Power BI Slicer<\/a>?<\/strong><\/em><\/p>\n

4. Using Measure in a Measure<\/h4>\n

You can also use an existing measure (created by you) in a new measure that you\u2019ll create. Suppose, we want a measure called Yearly Profit<\/strong> to have the profit value per year.<\/p>\n

Step 1:<\/strong> For this, select a table in which you wish to add this new measure and go to New measure<\/strong> option.<\/p>\n

Step 2:<\/strong> Then, enter the expression where we defined Yearly Profit as the difference of Projected Sales 2019 and Total Sales 2018. Here, ProjectedSales2019 is the measure we created earlier.<\/p>\n

\"measure<\/a><\/p>\n

As soon as we create this measure, it will get added to the Sales table.<\/p>\n

\"new<\/a><\/p>\n

Step 3:<\/strong> Now, we can use this new measure that used a pre-existing measure in its formula in a report. Notice in the screenshot below, we added an information card showing yearly profit value in our report page (highlighted in red box).<\/p>\n

\"using<\/a><\/p>\n

Summary<\/h2>\n

This concludes our tutorial on Measures in Power BI. In this article, we have learned about measures in Power BI and how we create and use them in Power BI desktop reports. You can use this knowledge to create any kind of measure expression for your reports.<\/p>\n

Now, you must check out the Power BI DAX tutorial<\/a>.<\/strong><\/em><\/p>\n

Hope the information given by us was useful to you. If you have any confusion regarding measures in Power BI, feel free to ask in the comment section.

In this tutorial, we are going to learn about measures in Power BI. Dealing with a huge set of data coming in from different data sources can be challenging and demanding. While most of...<\/p>\n","protected":false},"author":5,"featured_media":59314,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[20136,20134,20135],"class_list":["post-24313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-creating-measure-in-power-bi","tag-measures-in-power-bi","tag-using-measure-in-power-bi"],"yoast_head":"\nCreating and Using Measures in Power BI - A Complete Learning! - DataFlair<\/title>\n<meta name=\"description\" content=\"With Power BI measures tutorial, learn to create measure in Power BI desktop and use of measure in report, slicer and measure. Measures are those extras in Power BI which strengthens reporting capabilities even more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating and Using Measures in Power BI - A Complete Learning! - DataFlair\" \/>\n<meta property=\"og:description\" content=\"With Power BI measures tutorial, learn to create measure in Power BI desktop and use of measure in report, slicer and measure. Measures are those extras in Power BI which strengthens reporting capabilities even more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-16T09:30:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-14T12:36:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating and Using Measures in Power BI - A Complete Learning! - DataFlair","description":"With Power BI measures tutorial, learn to create measure in Power BI desktop and use of measure in report, slicer and measure. Measures are those extras in Power BI which strengthens reporting capabilities even more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Creating and Using Measures in Power BI - A Complete Learning! - DataFlair","og_description":"With Power BI measures tutorial, learn to create measure in Power BI desktop and use of measure in report, slicer and measure. Measures are those extras in Power BI which strengthens reporting capabilities even more.","og_url":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-16T09:30:43+00:00","article_modified_time":"2019-06-14T12:36:32+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Creating and Using Measures in Power BI – A Complete Learning!","datePublished":"2018-08-16T09:30:43+00:00","dateModified":"2019-06-14T12:36:32+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/"},"wordCount":1423,"commentCount":5,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg","keywords":["Creating Measure in Power BI","Measures in Power BI","Using Measure in Power BI"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/","url":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/","name":"Creating and Using Measures in Power BI - A Complete Learning! - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg","datePublished":"2018-08-16T09:30:43+00:00","dateModified":"2019-06-14T12:36:32+00:00","description":"With Power BI measures tutorial, learn to create measure in Power BI desktop and use of measure in report, slicer and measure. Measures are those extras in Power BI which strengthens reporting capabilities even more.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Measures-in-Power-BI-1.jpg","width":802,"height":420,"caption":"Measures in Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/measures-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Power BI Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"Creating and Using Measures in Power BI – A Complete Learning!"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=24313"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24313\/revisions"}],"predecessor-version":[{"id":59315,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/24313\/revisions\/59315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/59314"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=24313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=24313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=24313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}