{"id":14318,"date":"2024-09-03T05:32:59","date_gmt":"2024-09-03T05:32:59","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=14318"},"modified":"2025-12-03T16:35:15","modified_gmt":"2025-12-03T11:05:15","slug":"power-bi-finding-total-number-of-rows-in-a-table","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/","title":{"rendered":"How to Count Rows in Power Bi Table?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Summary: Counting rows is one of the fundamental task in Power BI. This blog takes you through different methods that unfold various methods to find the total number of rows.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Understanding_Power_BI_and_Its_Importance\" >Understanding Power BI and Its Importance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_to_Count_Rows_in_Power_Query\" >How to Count Rows in Power Query<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_A_Using_the_%22Count_Rows%22_Transformation\" >Method A: Using the \"Count Rows\" Transformation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_B_Using_the_TableRowCount_Function\" >Method B: Using the Table.RowCount Function<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_to_Check_the_Number_of_Rows_in_Power_Query\" >How to Check the Number of Rows in Power Query<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_A_Using_the_Status_Bar\" >Method A: Using the Status Bar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_B_Using_Column_Profiling\" >Method B: Using Column Profiling<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_to_Display_the_Total_Number_of_Records_in_Power_BI\" >How to Display the Total Number of Records in Power BI<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Step_1_Create_a_DAX_Measure_for_the_Row_Count\" >Step 1: Create a DAX Measure for the Row Count<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Step_2_Display_the_Count_in_a_Card_Visual\" >Step 2: Display the Count in a Card Visual<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_To_Get_Total_Number_of_Rows_in_Power_Query\" >How To Get Total Number of Rows in Power Query<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_1_Using_the_%22Count_Rows%22_Transformation_Easiest\" >Method 1: Using the \"Count Rows\" Transformation (Easiest)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Method_2_Using_the_TableRowCount_Function_Most_Flexible\" >Method 2: Using the Table.RowCount Function (Most Flexible)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_can_I_display_the_total_number_of_sales_transactions_on_a_dashboard_card\" >How can I display the total number of sales transactions on a dashboard card?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#How_do_I_quickly_verify_the_row_count_in_Power_Query_before_loading_a_large_file\" >How do I quickly verify the row count in Power Query before loading a large file?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#I_need_to_calculate_a_%22percentage_of_total%22_in_a_DAX_formula_How_do_I_get_the_total_row_count_for_the_calculation\" >I need to calculate a \"percentage of total\" in a DAX formula. How do I get the total row count for the calculation?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Accurate data representation is crucial in business. Amongst the different tools that are available<a href=\"https:\/\/www.pickl.ai\/blog\/most-promising-power-bi-project-ideas\/\"> Power BI<\/a> emerges as a powerful analytical tool. With the accurate data representation, it helps in precise data representation that is comprehensible to all. One of the common tasks that users face is determining the total number of rows in a table.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog, we will be covering the key details of how to count rows in Power BI. We will be highlighting the different methods that one can use to check number of rows in power query and how to display total number of records in power bi<\/p>\n\n\n\n<h2 id=\"understanding-power-bi-and-its-importance\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Understanding_Power_BI_and_Its_Importance\"><\/span><strong>Understanding Power BI and Its Importance<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI is a suite of <a href=\"https:\/\/www.pickl.ai\/blog\/big-data-analytics\/\">business analytics tools<\/a> that allows users to analyze data and share insights. It provides interactive visualizations and business intelligence capabilities with a simple interface for end users to create their own reports and dashboards.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The ability to count rows in a table is crucial for <a href=\"https:\/\/www.pickl.ai\/blog\/difference-between-data-analysis-and-interpretation\/\">data analysis<\/a>, as it helps users understand the size of their datasets, identify trends, and make informed decisions based on the data.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Whether you are working with sales data, customer information, or any other dataset, knowing how to count rows effectively in Power BI can enhance your reporting and <a href=\"https:\/\/www.pickl.ai\/blog\/exploring-key-analytical-capabilities\/\">analytics capabilities<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re just getting started with Power BI and want to build a strong foundation before learning tasks like counting rows, you can take a <a href=\"https:\/\/www.mygreatlearning.com\/academy\/learn-for-free\/courses\/data-visualization-with-power-bi\" rel=\"nofollow\">free power bi course<\/a>. This beginner-friendly course covers data visualization, dashboards, and essential Power BI concepts to help you learn faster and more confidently.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Read More:<\/strong><a href=\"https:\/\/www.pickl.ai\/blog\/power-bi-tutorial\/\"><strong> <\/strong><strong>Power BI Tutorial: A Complete Guide<\/strong><\/a><\/p>\n\n\n\n<h2 id=\"how-to-count-rows-in-power-query\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Count_Rows_in_Power_Query\"><\/span><strong>How to Count Rows in Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1000\" height=\"270\" src=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1.png\" alt=\"How to Count Rows in Power Query\" class=\"wp-image-24971\" srcset=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1.png 1000w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-300x81.png 300w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-768x207.png 768w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-110x30.png 110w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-200x54.png 200w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-380x103.png 380w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-255x69.png 255w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-550x149.png 550w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-800x216.png 800w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image1-1-150x41.png 150w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This method is for when you want the output of your query to be the actual row count.<\/p>\n\n\n\n<h3 id=\"method-a-using-the-count-rows-transformation\" class=\"wp-block-heading\"><strong>Method A: Using the &#8220;Count Rows&#8221; Transformation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is the simplest method and replaces your table with a single numerical value representing the row count.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>With your table open in the Power Query Editor, navigate to the <strong>Transform<\/strong> tab.<\/li>\n\n\n\n<li>In the <strong>Table<\/strong> group, click on <strong>Count Rows<\/strong>.<\/li>\n\n\n\n<li>The table will be replaced by a single number, which is the total count of rows.<\/li>\n<\/ol>\n\n\n\n<h3 id=\"method-b-using-the-table-rowcount-function\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_B_Using_the_TableRowCount_Function\"><\/span><strong>Method B: Using the Table.RowCount Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This M language function provides more flexibility and allows you to use the row count in subsequent steps or a separate query.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>To create a new query that only contains the row count:\n<ul class=\"wp-block-list\">\n<li>In the Power Query Editor, go to the <strong>Home<\/strong> tab.<\/li>\n\n\n\n<li>Click <strong>New Source<\/strong> &gt; <strong>Other Sources<\/strong> &gt; <strong>Blank Query<\/strong>.<\/li>\n\n\n\n<li>In the formula bar, type = Table.RowCount(YourTableName), replacing YourTableName with the name of the query you want to count.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>To add the row count as a step in an existing query:\n<ul class=\"wp-block-list\">\n<li>Select the query you are working on.<\/li>\n\n\n\n<li>Click the <strong>&#8220;fx&#8221;<\/strong> icon in the formula bar to add a new custom step.<\/li>\n\n\n\n<li>Enter = Table.RowCount(NameOfPreviousStep), replacing NameOfPreviousStep with the name of the prior step (e.g., &#8220;Changed Type&#8221;).<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 id=\"how-to-check-the-number-of-rows-in-power-query\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Check_the_Number_of_Rows_in_Power_Query\"><\/span><strong>How to Check the Number of Rows in Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Use these methods when you just need to see the number of rows for informational purposes without altering your data.<\/p>\n\n\n\n<h3 id=\"method-a-using-the-status-bar\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_A_Using_the_Status_Bar\"><\/span><strong>Method A: Using the Status Bar<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For a quick look, the bottom of the Power Query Editor provides a brief summary of your data.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open your query in the Power Query Editor.<\/li>\n\n\n\n<li>Look at the status bar in the bottom-left corner. It will display the number of columns and the number of rows loaded in the preview (e.g., &#8220;13 columns, 91 rows&#8221;).<\/li>\n\n\n\n<li><strong>Note:<\/strong> For large datasets, this count may be truncated and display &#8220;999+ rows&#8221;.<\/li>\n<\/ol>\n\n\n\n<h3 id=\"method-b-using-column-profiling\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_B_Using_Column_Profiling\"><\/span><strong>Method B: Using Column Profiling<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To get a more accurate count for larger datasets directly in the editor view:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the Power Query Editor, go to the <strong>View<\/strong> tab.<\/li>\n\n\n\n<li>In the <strong>Data Preview<\/strong> section, check the box for <strong>Column profiling<\/strong>.<\/li>\n\n\n\n<li>At the bottom of the editor, click on the text that says &#8220;Column profiling based on top 1000 rows&#8221;.<\/li>\n\n\n\n<li>Select <strong>&#8220;Column profiling based on entire data set&#8221;<\/strong>.<\/li>\n\n\n\n<li>The row count displayed in the status bar and column statistics will now reflect the entire dataset. Be aware this can slow down performance on very large tables.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"how-to-display-the-total-number-of-records-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Display_the_Total_Number_of_Records_in_Power_BI\"><\/span><strong>How to Display the Total Number of Records in Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After you have loaded your data from Power Query into Power BI, you can display the total row count in your reports and dashboards. The most common way is to use a Card visual with a DAX measure.<\/p>\n\n\n\n<h3 id=\"step-1-create-a-dax-measure-for-the-row-count\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Create_a_DAX_Measure_for_the_Row_Count\"><\/span><strong>Step 1: Create a DAX Measure for the Row Count<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In Power BI Desktop, go to the <strong>Report<\/strong> view.<\/li>\n\n\n\n<li>From the <strong>Home<\/strong> or <strong>Modeling<\/strong> tab, click on <strong>New Measure<\/strong>.<\/li>\n\n\n\n<li>In the formula bar that appears, enter the following DAX formula. Replace &#8216;YourTableName&#8217; with the actual name of your table:<br>Total Rows = COUNTROWS(&#8216;YourTableName&#8217;)<\/li>\n\n\n\n<li>Press <strong>Enter<\/strong> or click the checkmark to save the measure.<\/li>\n<\/ol>\n\n\n\n<h3 id=\"step-2-display-the-count-in-a-card-visual\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_Display_the_Count_in_a_Card_Visual\"><\/span><strong>Step 2: Display the Count in a Card Visual<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the <strong>Visualizations<\/strong> pane, click on the <strong>Card<\/strong> visual icon to add it to your report canvas.<\/li>\n\n\n\n<li>With the new Card visual selected, go to the <strong>Data<\/strong> pane.<\/li>\n\n\n\n<li>Find the Total Rows measure you just created and drag it into the <strong>Fields<\/strong> well of the Card visual.<\/li>\n\n\n\n<li>The card will now display the total number of records from your table.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"how-to-get-total-number-of-rows-in-power-query\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_To_Get_Total_Number_of_Rows_in_Power_Query\"><\/span><strong>How To Get Total Number of Rows in Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To find the total number of rows in Power Query, the simplest method is on the Transform tab\u2014just click Count Rows. This replaces your table with the total count. For more flexibility, you can use the M language function Table. RowCount(YourTable) in a new step or a separate query.<\/p>\n\n\n\n<h3 id=\"method-1-using-the-count-rows-transformation-easiest\" class=\"wp-block-heading\"><strong>Method 1: Using the &#8220;Count Rows&#8221; Transformation (Easiest)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is the most straightforward method. It replaces your entire table with a single value: the total row count. This is useful when the count itself is the final result you need.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Open your table<\/strong> in the Power Query Editor.<\/li>\n\n\n\n<li>Go to the <strong>&#8220;Transform&#8221;<\/strong> tab in the ribbon at the top.<\/li>\n\n\n\n<li>In the <strong>&#8220;Table&#8221;<\/strong> section, click the <strong>&#8220;Count Rows&#8221;<\/strong> icon.\n<ul class=\"wp-block-list\">\n<li><em>Result:<\/em> Your data table will be replaced by a single number representing the total count of rows.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 id=\"method-2-using-the-table-rowcount-function-most-flexible\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_2_Using_the_TableRowCount_Function_Most_Flexible\"><\/span><strong>Method 2: Using the Table.RowCount Function (Most Flexible)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This method uses a Power Query M language function. It&#8217;s ideal when you need to use the row count in another calculation or want to create a separate query that just shows the count without changing your original table.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Open the Power Query Editor.<\/strong><\/li>\n\n\n\n<li>Make sure the <strong>Formula Bar<\/strong> is visible. If not, go to the <strong>&#8220;View&#8221;<\/strong> tab and check the box for <strong>&#8220;Formula Bar&#8221;<\/strong>.<\/li>\n\n\n\n<li>Decide where you want the count:<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Option A: As a new step in your current query:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the last step in your <strong>&#8220;Applied Steps&#8221;<\/strong> pane on the right.<\/li>\n\n\n\n<li>Click the <strong>&#8220;fx&#8221;<\/strong> icon next to the formula bar to create a new custom step.<\/li>\n\n\n\n<li>Type = Table.RowCount(NameOfPreviousStep) in the formula bar, replacing NameOfPreviousStep with the actual name of the previous step (e.g., &#8220;Changed Type&#8221;).<\/li>\n\n\n\n<li>Press <strong>Enter<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Option B: As a completely new query:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>&#8220;Home&#8221;<\/strong> tab, click <strong>&#8220;New Source&#8221;<\/strong> &gt; <strong>&#8220;Other Sources&#8221;<\/strong> &gt; <strong>&#8220;Blank Query&#8221;<\/strong>.<\/li>\n\n\n\n<li>A new query will be created. In its formula bar, type = Table.RowCount(YourTableName), replacing YourTableName with the name of the table you want to count.<\/li>\n\n\n\n<li>Press <strong>Enter<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Whether you need a quick check in Power Query using &#8220;Count Rows&#8221; or a dynamic display in a Power BI report with a COUNTROWS DAX measure, both tools provide simple and effective methods. Choosing the right technique depends on whether you are preparing data or <a href=\"https:\/\/www.pickl.ai\/blog\/data-analysis-and-data-visualization\/\">visualizing the final result<\/a>.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"how-can-i-display-the-total-number-of-sales-transactions-on-a-dashboard-card\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_can_I_display_the_total_number_of_sales_transactions_on_a_dashboard_card\"><\/span><strong>How can I display the total number of sales transactions on a dashboard card?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To show a live count, create a DAX measure using the formula: Total Transactions = COUNTROWS(&#8216;SalesTable&#8217;). Then, add a &#8220;Card&#8221; visual to your report and drag this new measure into it. The card will now display the total number of rows, updating automatically with your data.<\/p>\n\n\n\n<h3 id=\"how-do-i-quickly-verify-the-row-count-in-power-query-before-loading-a-large-file\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_I_quickly_verify_the_row_count_in_Power_Query_before_loading_a_large_file\"><\/span><strong>How do I quickly verify the row count in Power Query before loading a large file?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">In the Power Query Editor, select your query. Go to the &#8220;Transform&#8221; tab and click &#8220;Count Rows.&#8221; This action replaces the data preview with a single number representing the total row count. You can then remove this step from &#8220;Applied Steps&#8221; before closing and applying the changes.<\/p>\n\n\n\n<h3 id=\"i-need-to-calculate-a-percentage-of-total-in-a-dax-formula-how-do-i-get-the-total-row-count-for-the-calculation\" class=\"wp-block-heading\"><strong>I need to calculate a &#8220;percentage of total&#8221; in a DAX formula. How do I get the total row count for the calculation?<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">First, create a base measure like Total Records = COUNTROWS(&#8216;YourTable&#8217;). You can then use this measure as the denominator in other DAX calculations. For example, DIVIDE([Category Count], [Total Records]) will give you the percentage of total, ensuring your calculations are clean and efficient.<\/p>\n","protected":false},"excerpt":{"rendered":"Master row counting in Power BI with best practices and troubleshooting tips\n","protected":false},"author":28,"featured_media":24972,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2293],"tags":[2909,2910,2911],"ppma_author":[2218,2631],"class_list":["post-14318","post","type-post","status-publish","format-standard","has-post-thumbnail","category-power-bi","tag-how-to-display-total-number-of-records-in-power-bi","tag-how-to-get-total-number-of-rows-in-power-query","tag-power-query-get-number-of-rows-in-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Power BI Finding Total Number of Rows in a Table<\/title>\n<meta name=\"description\" content=\"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Count Rows in Power Bi Table?\" \/>\n<meta property=\"og:description\" content=\"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-03T05:32:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-03T11:05:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"624\" \/>\n\t<meta property=\"og:image:height\" content=\"391\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Karan Thapar, Kajal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karan Thapar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/\"},\"author\":{\"name\":\"Karan Thapar\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/436765181b3cae18e64558738587a643\"},\"headline\":\"How to Count Rows in Power Bi Table?\",\"datePublished\":\"2024-09-03T05:32:59+00:00\",\"dateModified\":\"2025-12-03T11:05:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/\"},\"wordCount\":1481,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image2-7.jpg\",\"keywords\":[\"how to display total number of records in power bi\",\"how to get total number of rows in power query\",\"power query get number of rows in table\"],\"articleSection\":[\"Power BI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/\",\"name\":\"Power BI Finding Total Number of Rows in a Table\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image2-7.jpg\",\"datePublished\":\"2024-09-03T05:32:59+00:00\",\"dateModified\":\"2025-12-03T11:05:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/436765181b3cae18e64558738587a643\"},\"description\":\"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image2-7.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/image2-7.jpg\",\"width\":624,\"height\":391,\"caption\":\"Counting rows in Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/power-bi-finding-total-number-of-rows-in-a-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/power-bi\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Count Rows in Power Bi Table?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/436765181b3cae18e64558738587a643\",\"name\":\"Karan Thapar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_28_1723028665-96x96.jpg18587524b8ed08387eb1381ceaf831ac\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_28_1723028665-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_28_1723028665-96x96.jpg\",\"caption\":\"Karan Thapar\"},\"description\":\"Karan Thapar, a content writer, finds joy in immersing in nature, watching football, and keeping a journal. His passions extend to attending music festivals and diving into a good book. In his current exploration, He writes into the world of recent technological advancements, exploring their impact on the global landscape.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/karanthapar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI Finding Total Number of Rows in a Table","description":"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.","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:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/","og_locale":"en_US","og_type":"article","og_title":"How to Count Rows in Power Bi Table?","og_description":"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.","og_url":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/","og_site_name":"Pickl.AI","article_published_time":"2024-09-03T05:32:59+00:00","article_modified_time":"2025-12-03T11:05:15+00:00","og_image":[{"width":624,"height":391,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","type":"image\/jpeg"}],"author":"Karan Thapar, Kajal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Karan Thapar","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/"},"author":{"name":"Karan Thapar","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/436765181b3cae18e64558738587a643"},"headline":"How to Count Rows in Power Bi Table?","datePublished":"2024-09-03T05:32:59+00:00","dateModified":"2025-12-03T11:05:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/"},"wordCount":1481,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","keywords":["how to display total number of records in power bi","how to get total number of rows in power query","power query get number of rows in table"],"articleSection":["Power BI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/","url":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/","name":"Power BI Finding Total Number of Rows in a Table","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","datePublished":"2024-09-03T05:32:59+00:00","dateModified":"2025-12-03T11:05:15+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/436765181b3cae18e64558738587a643"},"description":"Power Bi ensures accurate data visualization, learn how to find the total number of rows in table and its various methods.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","width":624,"height":391,"caption":"Counting rows in Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/power-bi-finding-total-number-of-rows-in-a-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI","item":"https:\/\/www.pickl.ai\/blog\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"How to Count Rows in Power Bi Table?"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/436765181b3cae18e64558738587a643","name":"Karan Thapar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_28_1723028665-96x96.jpg18587524b8ed08387eb1381ceaf831ac","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_28_1723028665-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_28_1723028665-96x96.jpg","caption":"Karan Thapar"},"description":"Karan Thapar, a content writer, finds joy in immersing in nature, watching football, and keeping a journal. His passions extend to attending music festivals and diving into a good book. In his current exploration, He writes into the world of recent technological advancements, exploring their impact on the global landscape.","url":"https:\/\/www.pickl.ai\/blog\/author\/karanthapar\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/09\/image2-7.jpg","authors":[{"term_id":2218,"user_id":28,"is_guest":0,"slug":"karanthapar","display_name":"Karan Thapar","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_28_1723028665-96x96.jpg","first_name":"Karan","user_url":"","last_name":"Thapar","description":"Karan Thapar, a content writer, finds joy in immersing herself in nature, watching football, and keeping a journal. His passions extend to attending music festivals and diving into a good book. In his current exploration,He writes into the world of recent technological advancements, exploring their impact on the global landscape."},{"term_id":2631,"user_id":38,"is_guest":0,"slug":"kajal","display_name":"Kajal","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_38_1722418842-96x96.jpg","first_name":"Kajal","user_url":"","last_name":"","description":"Kajal has joined our Organization as an Analyst in Gurgaon. She did her Graduation in B.sc(H) in Computer Science from Keshav Mahavidyalaya, Delhi University, and Masters in Computer Application from Indira Gandhi Delhi Technical University For Women, Kashmere Gate. Her expertise lies in Python, SQL, ML, and Data visualization. Her hobbies are Reading Self Help books, Writing gratitude journals, Watching cricket, and Reading articles."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/14318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=14318"}],"version-history":[{"count":9,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/14318\/revisions"}],"predecessor-version":[{"id":25540,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/14318\/revisions\/25540"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/24972"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=14318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=14318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=14318"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=14318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}