{"id":4139,"date":"2016-08-11T00:44:09","date_gmt":"2016-08-10T22:44:09","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4139"},"modified":"2024-02-06T15:58:34","modified_gmt":"2024-02-06T14:58:34","slug":"using-countrows-power-pivot","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/using-countrows-power-pivot\/","title":{"rendered":"COUNTROWS in Excel Power Pivot"},"content":{"rendered":"<p>&nbsp;<\/p>\n<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 use the <strong>COUNTROWS<\/strong> function in your\u00a0<strong>Measure.<\/strong><\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/twL_9gzILXk?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><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle 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<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows.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\">Countrows.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\/08\/Countrows-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4143\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-01.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"410\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-01.png 410w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-01-300x286.png 300w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/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\/08\/Countrows-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4144\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-02.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"733\" height=\"407\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-02.png 733w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-02-300x167.png 300w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/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\/08\/Countrows-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4145\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-03.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"643\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-03.png 643w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-03-300x183.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/a><\/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\/08\/Countrows-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4146\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-04.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"583\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-04.png 583w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-04-300x175.png 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/a><\/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><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\/Countrows-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4147\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-05.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"387\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-05.png 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-05-300x268.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/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>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><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>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\/08\/Countrows-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4148\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-06.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-06.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-06-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/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><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><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>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 <strong>Measure<\/strong>\u00a0using the <strong>COUNTROWS\u00a0<\/strong>function.<\/p>\n<p>For <strong>Measure Name,\u00a0<\/strong>type in any name that you like e.g.<strong>\u00a0<i>Number of Sales<\/i><\/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 <b><i>COUNTROWS<\/i><\/b>.<\/p>\n<p>Just like in native Excel, this will bring up the Formula helper and choose the <em>COUNTROWS\u00a0<\/em>function by either <strong>double clicking<\/strong> on the blue highlighted <em>COUNTROWS\u00a0<\/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\/Countrows-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4149\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-07.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"521\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-07.png 521w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-07-300x104.png 300w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>After the <em>COUNTROWS\u00a0<\/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<\/strong><\/em>\u00a0Table option and\u00a0close the parenthesis:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4150\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-08.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"510\" height=\"244\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-08.png 510w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-08-300x144.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Set the\u00a0<strong>Category\u00a0<\/strong>as <b>General<\/b>, 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 Total Number of Rows\u00a0based on the Pivot Table we will be setting up in the next step.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4151\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-09.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"561\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-09.png 561w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-09-300x231.png 300w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8:<\/span>\u00a0<\/strong>Place your new Measure\u00a0<strong><em>Number of Sales<\/em>\u00a0<\/strong>in the\u00a0<strong>Values\u00a0<\/strong>area.<\/p>\n<p>Then place\u00a0<strong><em>Month<\/em>\u00a0<\/strong>in the\u00a0<strong>Rows\u00a0<\/strong>area<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4152\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-10.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-10.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-10-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/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 <strong>COUNTROW\u00a0Measure<\/strong> in the\u00a0<strong>Pivot Table.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"COUNTROWS in Excel Power Pivot\"  class=\"alignnone size-full wp-image-4153\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Countrows-11.png\" alt=\"COUNTROWS in Excel Power Pivot\" width=\"210\" height=\"134\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\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","protected":false},"excerpt":{"rendered":"<p>&nbsp; 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 use the COUNTROWS function in your\u00a0Measure. \ufeff download excel workbook [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17395,"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":[167,145],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4139"}],"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=4139"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4139\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17395"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}