{"id":4059,"date":"2016-08-04T17:41:08","date_gmt":"2016-08-04T15:41:08","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4059"},"modified":"2024-02-06T15:58:32","modified_gmt":"2024-02-06T14:58:32","slug":"using-measures-power-pivot","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-measures-power-pivot\/","title":{"rendered":"Using Measures in Power Pivot"},"content":{"rendered":"<p>In <strong>Power Pivot, <\/strong>one of the major and more powerful feature are\u00a0<strong>Measures<\/strong>.<\/p>\n<p>Measures (also known as Calculated Fields in Excel 2013) are\u00a0formulas\/calculations that are added to a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Table<\/a>.<\/p>\n<p>We will work on a simple example to show you how easy it is to add your first\u00a0<strong>Measure.<\/strong><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-measures-power-pivot\/#Want_to_learn_about_Measures_vs_Calculated_Columns_in_Power_Pivot\" title=\"Want to learn about Measures vs Calculated Columns in Power Pivot?\">Want to learn about Measures vs Calculated Columns in Power Pivot?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_learn_about_Measures_vs_Calculated_Columns_in_Power_Pivot\"><\/span><em><strong>Want to learn about Measures vs Calculated Columns in Power Pivot?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/uj0HaAeboCQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/uj0HaAeboCQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Measures.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong><\/span>: Select the <strong>Sales Table<\/strong>. Go to <strong>Insert &gt;\u00a0Table. \u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4061\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-01.png\" alt=\"Using Measures in Power Pivot\" width=\"334\" height=\"376\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-01.png 334w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-01-266x300.png 266w\" sizes=\"(max-width: 334px) 100vw, 334px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to<strong> Table Tools &gt;\u00a0Design &gt; Table Name\u00a0<\/strong> and give your new Table a descriptive name.\u00a0In our example, we will name it\u00a0<em><strong>Sales<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4062\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-02.png\" alt=\"Using Measures in Power Pivot\" width=\"341\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-02.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-02-269x300.png 269w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span><\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2013 &amp; 2016<\/strong><\/span><\/p>\n<p>Select your <em>Sales<\/em>\u00a0Table. Go to <strong>Power Pivot &gt; Add to Data Model<\/strong>.<\/p>\n<p>This will import your new Table into the\u00a0<strong>Power Pivot Window<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4063\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-03.png\" alt=\"Using Measures in Power Pivot\" width=\"659\" height=\"376\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-03.png 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-03-300x171.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2010<\/strong><\/span><\/p>\n<p>Go to<strong> <strong>PowerPivot &gt;\u00a0Create Linked Table.<\/strong><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Linking Excel Tables in Power Pivot\"  class=\"alignnone size-full wp-image-3958\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png\" alt=\"Linking Excel Tables in Power Pivot\" width=\"1009\" height=\"142\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table.png 1009w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table-300x42.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Excel-2010-Create-Linked-Table-768x108.png 768w\" sizes=\"(max-width: 1009px) 100vw, 1009px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span>\u00a0<\/strong>This will open the\u00a0<strong>Power Pivot Window<\/strong>.<\/p>\n<p>The\u00a0<strong>Sales<\/strong> Table will now\u00a0be automatically loaded to the <strong>Power Pivot Data Model<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4064\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-04.png\" alt=\"Using Measures in Power Pivot\" width=\"624\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-04.png 624w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-04-300x148.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now <strong>Close<\/strong> the\u00a0<strong>Power Pivot Window.\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-08-02_16-09-36.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4081\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/2016-08-02_16-09-36.png\" alt=\"Using Measures in Power Pivot\" width=\"252\" height=\"213\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0Go to<strong>\u00a0Insert<strong>&gt; <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a><\/strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-05a.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4070\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-05a.png\" alt=\"Using Measures in Power Pivot\" width=\"350\" height=\"136\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-05a.png 350w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-05a-300x117.png 300w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\"><strong>In Excel 2016<\/strong><\/span><\/span><\/p>\n<p>Select<strong>\u00a0Use this workbook&#8217;s Data Model<\/strong>. \u00a0This will use the Data Model you just uploaded in the last step.<\/p>\n<p>Select\u00a0<strong>Existing Worksheet<\/strong> and choose\u00a0your location for your Pivot Table and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Measures-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4120\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Measures-05.png\" alt=\"Using Measures in Power Pivot\" width=\"548\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Measures-05.png 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Measures-05-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Measures-05-150x150.png 150w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2013<\/strong><\/span><\/p>\n<p>Go to<strong> Use External Data Source &gt; Choose a Connection<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4106\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png\" alt=\"Using Measures in Power Pivot\" width=\"385\" height=\"283\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png 385w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection-300x221.png 300w\" sizes=\"(max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now select\u00a0<strong>Tables &gt; This Workbooks Data Model &gt; Open<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Existing-Connections.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4098\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Existing-Connections.jpg\" alt=\"Using Measures in Power Pivot\" width=\"486\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Existing-Connections.jpg 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Existing-Connections-296x300.jpg 296w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2010<\/strong><\/span><\/p>\n<p>Go to<strong> Use an External Data Source &gt; Choose Connection:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4106\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png\" alt=\"Using Measures in Power Pivot\" width=\"385\" height=\"283\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection.png 385w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/excel-2010-measure-connection-300x221.png 300w\" sizes=\"(max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now select\u00a0<strong>PowerPivot\u00a0Data &gt; Open<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Existing-Connections.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4097\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Existing-Connections.jpg\" alt=\"Using Measures in Power Pivot\" width=\"486\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Existing-Connections.jpg 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Existing-Connections-296x300.jpg 296w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span>\u00a0Adding a Measure:<\/strong><\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2016<\/strong><\/span><\/p>\n<p>On the\u00a0<strong>Sales<\/strong>\u00a0Table, right click and select\u00a0<strong>Add Measure.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4066\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-06.png\" alt=\"Using Measures in Power Pivot\" width=\"366\" height=\"649\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-06.png 366w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-06-169x300.png 169w\" sizes=\"(max-width: 366px) 100vw, 366px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>An alternative way in\u00a0<strong>Excel 2016<\/strong>\u00a0is go to <strong>Power Pivot &gt; Measures\u00a0&gt; New Measure.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2016-Add-Measure.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4103\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2016-Add-Measure.png\" alt=\"Using Measures in Power Pivot\" width=\"777\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2016-Add-Measure.png 777w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2016-Add-Measure-300x64.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2016-Add-Measure-768x165.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2013<\/strong><\/span><\/p>\n<p>Go to<strong>\u00a0PowerPivot &gt; Calculated Fields &gt; New Calculated Field<\/strong><\/p>\n<p>(<em>In Excel 2013 &#8220;Measures&#8221; were renamed &#8220;Calculated Fields&#8221; and returned to &#8220;Measures&#8221; in Excel 2016&#8230;I know, how annoying!<\/em>)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Add-Measure.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4102\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Add-Measure.jpg\" alt=\"Using Measures in Power Pivot\" width=\"917\" height=\"156\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Add-Measure.jpg 917w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Add-Measure-300x51.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2013-Add-Measure-768x131.jpg 768w\" sizes=\"(max-width: 917px) 100vw, 917px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>In Excel 2010<\/strong><\/span><\/p>\n<p>On the\u00a0<strong>Sales<\/strong> table, right click and select\u00a0<strong>Add New Measure.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Add-Measure.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4099\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/2010-Add-Measure.jpg\" alt=\"Using Measures in Power Pivot\" width=\"233\" height=\"179\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>An alternative way in\u00a0<strong>Excel 2010<\/strong>\u00a0is to select a cell inside the Pivot Table that was created in the previous step and go to <strong>Power Pivot &gt; New Measure:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/new-measure-excel-2010.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4108\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/new-measure-excel-2010.png\" alt=\"Using Measures in Power Pivot\" width=\"676\" height=\"117\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/new-measure-excel-2010.png 676w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/new-measure-excel-2010-300x52.png 300w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 7:<\/span>\u00a0<\/strong>This is where we create our first\u00a0<strong>Measure.<\/strong><\/p>\n<p>For <strong>Measure Name,\u00a0<\/strong>type in any name that you like e.g.<strong>\u00a0<\/strong><strong><em>Total Sales<\/em><\/strong><\/p>\n<p>For the\u00a0<strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formula\" data-wpil-keyword-link=\"linked\">Formula<\/a><\/strong>, after the <strong>=<\/strong> sign start typing the word <em><strong>SUM<\/strong><\/em>.<\/p>\n<p>Just like in native Excel, this will bring up the Formula helper and choose the <em>SUM <\/em>function by either <strong>double clicking<\/strong> on the blue highlighted <em>SUM<\/em> option or by pressing the <strong>Tab<\/strong> keyboard to confirm this suggestion:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/sum.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4111\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/sum.png\" alt=\"Using Measures in Power Pivot\" width=\"290\" height=\"175\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>After the <em>SUM<\/em> formula is selected, <strong>type in the Table name<\/strong> that we created in <strong>Step 2<\/strong>, which we called <em><strong>Sales<\/strong><\/em>.<\/p>\n<p>This will bring up the Formula helper and within here you need to select the <em><strong>Sales [Sales Amount]<\/strong><\/em> option and\u00a0close the parenthesis:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/sales-amount.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4113\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/sales-amount.png\" alt=\"Using Measures in Power Pivot\" width=\"262\" height=\"200\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Set the\u00a0<strong>Category\u00a0<\/strong>as\u00a0<strong>Currency<\/strong>, and this will automatically handle the formatting for you. \u00a0Press <strong>OK<\/strong> to confirm this.<\/p>\n<p>This Measure will now return\u00a0the Sum Total of the <em>Sales Amount<\/em> column within the <strong><em>Sales<\/em>\u00a0<\/strong>Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4067\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-07.png\" alt=\"Using Measures in Power Pivot\" width=\"564\" height=\"434\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-07.png 564w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-07-300x231.png 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8:<\/span>\u00a0<\/strong>Place your new Measure\u00a0<strong><em>Total Sales<\/em>\u00a0<\/strong>in the\u00a0<strong>Values\u00a0<\/strong>area.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4068\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-08.png\" alt=\"Using Measures in Power Pivot\" width=\"345\" height=\"641\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-08.png 345w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-08-161x300.png 161w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 9:<\/span>\u00a0<\/strong>Now we are able to use our new\u00a0<strong>Measure<\/strong> in the\u00a0<strong>Pivot Table.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Using Measures in Power Pivot\"  class=\"alignnone size-full wp-image-4069\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Measures-09.png\" alt=\"Using Measures in Power Pivot\" width=\"196\" height=\"105\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\"><strong>Further Learning:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/importing-excel-workbooks-power-pivot\/\" target=\"_blank\" rel=\"noopener\">Importing Excel Workbooks in Power Pivot<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/linking-excel-tables-power-pivot\/\" target=\"_blank\" rel=\"noopener\">Linking Excel Tables in Power Pivot<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unpivot-data-using-excel-power-query\/\" target=\"_blank\" rel=\"noopener\">Unpivot Data Using Excel Power Query<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2964 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/728x90.gif\" alt=\"PIVOT BANNER\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In Power Pivot, one of the major and more powerful feature are\u00a0Measures. Measures (also known as Calculated Fields in Excel 2013) are\u00a0formulas\/calculations that are added to a Pivot Table. We will work on a simple example to show you how easy it is to add your first\u00a0Measure. Want to learn about Measures vs Calculated Columns [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15043,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[120,122],"tags":[164,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4059"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=4059"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4059\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15043"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}