{"id":46711,"date":"2025-01-29T20:33:35","date_gmt":"2025-01-29T15:33:35","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=46711"},"modified":"2025-12-16T22:51:18","modified_gmt":"2025-12-16T17:51:18","slug":"power-bi-sumif","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/power-bi-sumif","title":{"rendered":"Power BI SUMIF for Advanced Reporting"},"content":{"rendered":"<p>The Data Analysis Expressions (DAX) is a software library that holds functions and operators that are important in streamlining the use of Power BI. With the rich DAX functions, you can create expressions that will perform complex Power BI tasks.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/power-bi-sumif.jpg\" alt=\"Power BI SUMIF\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MzUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>For instance, DAX functions can be used in creating an expression (formula) that reads an input statement and returns one of the specified values. Simply put, DAX can use the available data to generate new information.<\/p>\n<p>In this guide, you\u2019ll discover what the SUMIF function in Power BI is, why it is important, and the key features of DAX SUMIF functions.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#what-is-the-sumif-function-in-power-bi\">What is the SUMIF function in Power BI?<\/a><\/li>\n<li><a href=\"#why-is-power-bi-sumif-important\">Why is Power BI SUMIF Important?<\/a><\/li>\n<li><a href=\"#what-is-the-role-of-sumif-in-dax\">What is the Role of SUMIF in DAX?<\/a><\/li>\n<li><a href=\"#what-are-the-key-features-of-dax-sumif-functions\">What are the Key Features of DAX SUMIF Functions?<\/a><\/li>\n<li><a href=\"#how-to-use-sumif-in-power-bi-to-evaluate-data\">How to Use SUMIF in Power BI to Evaluate Data?<\/a><\/li>\n<li><a href=\"#power-bi-sumif-equivalent-function-calculate\">Power BI SUMIF Equivalent Function: CALCULATE<\/a><\/li>\n<li><a href=\"#power-bi-sumif-equivalent-function-filter\">Power BI SUMIF Equivalent Function: FILTER<\/a><\/li>\n<li><a href=\"#how-to-create-a-dashboard-in-power-bi\">How to Analyze Data Using SUMIF Logic in Power BI?<\/a><\/li>\n<li><a href=\"#what-are-the-benefits-of-the-power-bi-sumif-function\">What are the Benefits of the Power BI SUMIF Function?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-the-sumif-function-in-power-bi\">What is the SUMIF function in Power BI?<\/h2>\n<p>Power BI SUMIF function allows the user to sum values in a column based on a specified condition (or criteria). Here\u2019s how to use the SUMIF function in Power BI:<\/p>\n<p>SUMIF = SUMX(FILTER(TableName,[CriteriaColumn] = \u201cCondition\u201d),[SumColumn])<\/p>\n<ul>\n<li>TableName: This is the name of the table that contains the data you want to evaluate.<\/li>\n<li>[CriteriaColumn]: This is the column that contains the criteria (or conditions) you want to apply.<\/li>\n<li>\u201cCondition\u201d: This is the specific value (or condition) you want to filter on.<\/li>\n<li>[SumColumn]: This is the column that contains the values you want to sum based on the condition.<\/li>\n<\/ul>\n<h2 id=\"why-is-power-bi-sumif-important\">Why is Power BI SUMIF Important?<\/h2>\n<p>SUMIF function in Power BI helps to streamline <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> and reporting processes. It also provides users with a powerful tool to extract valuable insights from complex datasets. Since it allows users to aggregate data based on specific conditions (or criteria), that helps to boost the accuracy, efficiency, and relevance of analytical tasks.<\/p>\n<p>Furthermore, SUMIF facilitates conditional aggregation \u2014 and that comes in handy when <a href=\"https:\/\/chartexpo.com\/blog\/analyzing-and-interpreting-data\" target=\"_blank\" rel=\"noopener\">analyzing and interpreting data<\/a> in context. SUMIF enables the user to tailor their analyses to meet specific business requirements.<\/p>\n<h2 id=\"what-is-the-role-of-sumif-in-dax\">What is the Role of SUMIF in DAX?<\/h2>\n<p>SUMIF function in DAX helps to <a href=\"https:\/\/chartexpo.com\/blog\/what-is-aggregated-data\" target=\"_blank\" rel=\"noopener\">aggregate data<\/a> based on specified conditions (or criteria). The SUMIF function in DAX, just like its counterpart in Excel, allows users to sum values from a column that meets certain criteria and also filters the data as needed.<\/p>\n<h2 id=\"what-are-the-key-features-of-dax-sumif-functions\">What are the Key Features of DAX SUMIF Functions?<\/h2>\n<ul>\n<li><strong>Measures:<\/strong> Measures are dynamic expressions for calculation stored in the <a href=\"https:\/\/chartexpo.com\/blog\/what-is-dax-in-power-bi\" target=\"_blank\" rel=\"noopener\">DAX Function<\/a> library. The Measure result transforms based on the input data&#8217;s context. You can create Measures from the DAX formula bar present on the model designer. You can also move measures between tables without causing any loss of functionality.<\/li>\n<li><strong>Calculated Columns:<\/strong> Calculated columns store the computational results obtained by performing operations on two or more columns during a data refresh. Calculated columns are created to perform row-level calculations and build an output column in the table. The feature consumes RAM (Random Access Memory), and it should not be implemented during the production stage.<\/li>\n<li><strong>Row-level Security:<\/strong> DAX Functions maintain the row-level security of the Power BI tables. That is, all DAX evaluations provide only a boolean result (True or False). This allows the row set to be created at once and no other users are allowed to access it. Moving on, DAX depends upon filters to keep the currently active relationship safe.<\/li>\n<li><strong>High Performance:<\/strong> DAX functions provide fast data processing and <a href=\"https:\/\/chartexpo.com\/blog\/best-designed-dashboards\" target=\"_blank\" rel=\"noopener\">intelligent dashboard<\/a>s. It upgrades the calculations in Power BI and ensures efficient querying of data. You can connect Power BI with external sources and directly implement DAX functions on source data.<\/li>\n<\/ul>\n<h2 id=\"how-to-use-sumif-in-power-bi-to-evaluate-data\">How to Use SUMIF in Power BI to Evaluate Data?<\/h2>\n<p>In this section, you&#8217;ll sum up subjects with higher than 15 midterm marks. You can obtain the results using the following Power BI SUMIF functions:<\/p>\n<ul>\n<li>Power BI SUMIF Equivalent Function: CALCULATE<\/li>\n<li>Power BI SUMIF Equivalent Function: FILTER.<\/li>\n<\/ul>\n<h2 id=\"power-bi-sumif-equivalent-function-calculate\">Power BI SUMIF Equivalent Function: CALCULATE<\/h2>\n<p>The CALCULATE Function in Power BI DAX helps in achieving accurate results from complex calculations. For instance, <a href=\"https:\/\/chartexpo.com\/blog\/calculate-function-in-power-bi\" target=\"_blank\" rel=\"noopener\">CALCULATE<\/a> can be used as a Power BI SUMIF equivalent function:<\/p>\n<p>sumif = CALCULATE(SUM(Marks[Mid term Marks]),Marks[Mid term Marks] &gt; 15)<\/p>\n<p>The above syntax of SUMIF in Power BI uses at least two parameters:<\/p>\n<ul>\n<li>Expression: From the formula above, the first parameter is an expression showing the addition process as \u201cSUM(Marks[Mid term Marks]).\u201d The expression aggregates the midterm marks for all students.<\/li>\n<li>Filter: The filter plays a crucial role when applying the conditional aspect of the SUMIF Function. You\u2019ll have to calculate the total midterm marks for subjects that come under the condition \u201cMarks[Mid term Marks] &gt; 15.<\/li>\n<\/ul>\n<p>The image below shows the output of the Power BI SUMIF equivalent CALCULATE Function.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/image-below-shows-output-of-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/image-below-shows-output-of-power-bi-sumif.jpg\" alt=\"Image Below Shows Output of Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"power-bi-sumif-equivalent-function-filter\">Power BI SUMIF Equivalent Function: FILTER<\/h2>\n<p>The <a href=\"https:\/\/chartexpo.com\/blog\/filters-in-power-bi\" target=\"_blank\" rel=\"noopener\">FILTER Function<\/a> is another equivalent of the SUMIF Power BI. It\u2019s a table-based function that returns a table as output.<\/p>\n<p>sumif = SUMX(FILTER(Marks,Marks[Mid term Marks] &gt; 15),Marks[Mid term Marks])<\/p>\n<p>The Power BI SUMIF equivalent FILTER Function above uses two parameters:<\/p>\n<ul>\n<li>Table: The first parameter is a table that the user can input in the form of a complete Table (or as a single-column Table) with the help of the \u201cAll()\u201d function in DAX. The SUMX Function in the expression above requires a Table as the first parameter.<\/li>\n<li>Filter: The \u201cFILTER(Marks, Marks[Mid term Marks] &gt; 15)\u201d parameter uses the FILTER Function to aggregate midterm marks only for subjects having marks higher than 15.<\/li>\n<\/ul>\n<p>The first step involves clicking the modeling tab at the top to generate an input Table. After that, select the \u201cNew Table\u201d option. Using the FILTER Function, you will generate a table similar to the one below:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/use-filter-function-for-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/use-filter-function-for-doing-power-bi-sumif.jpg\" alt=\"Use Filter Function for Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<p>Using the table as input to the SUMX Function, you\u2019ll have to drag the measure \u201csumif w filter\u201d onto the report. Use the SUMX Function to a result similar to the one below:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/use-sumx-function-to-result-similar-for-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/use-sumx-function-to-result-similar-for-doing-power-bi-sumif.jpg\" alt=\"Use SUMX Function to Result Similar for Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"how-to-create-a-dashboard-in-power-bi\">How to Analyze Data Using SUMIF Logic in Power BI?<\/h2>\n<p>You can use the <a href=\"https:\/\/chartexpo.com\/blog\/sankey-diagram-in-power-bi\" target=\"_blank\" rel=\"noopener\">Sankey chart in Power BI<\/a> to visualize the results of SUMIF logic and understand how values flow across different categories.<\/p>\n<h3>Stage 1: Log into Power BI, enter your email, and click \u201cSubmit.\u201d<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email address and click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<h3>Stage 2: Create a Data Set and Select the Data Set to Use in the Sankey Chart<\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\" alt=\"select Paste or manually enter data in Power BI ce487\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MzUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the <a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">sample data<\/a> below for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td><strong>Application Channels<\/strong><\/td>\n<td><strong>Initial Screening<\/strong><\/td>\n<td><strong>Conduct Interviews<\/strong><\/td>\n<td><strong>Employee Onboarding<\/strong><\/td>\n<td>\n<div>\n<div><strong>Total Candidates<\/strong><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>32<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>400<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>800<\/td>\n<\/tr>\n<tr>\n<td>Social Media<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>1100<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>20<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>250<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>500<\/td>\n<\/tr>\n<tr>\n<td>Company Career Page<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>900<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>5<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>100<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>200<\/td>\n<\/tr>\n<tr>\n<td>Events<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>350<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>135<\/td>\n<\/tr>\n<tr>\n<td>Paper Media<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>700<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>70<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>Employee Referrals<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>110<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Hired<\/td>\n<td>25<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Final Interview<\/td>\n<td>Not Hired<\/td>\n<td>150<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Short Listed<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td>425<\/td>\n<\/tr>\n<tr>\n<td>Direct<\/td>\n<td>Knocked Out<\/td>\n<td><\/td>\n<td><\/td>\n<td>600<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To add data to the report, you\u2019ll have to paste the data table above into the \u201c<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-vs-power-query\" target=\"_blank\" rel=\"noopener\">Power Query<\/a>\u201d window. Next, select the \u201cCreate a dataset only\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-create-a-dataset-only-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-create-a-dataset-only-after-doing-power-bi-sumif.jpg\" alt=\"Select Create a Dataset Only After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click on the &#8220;Data Hub&#8221; option. Power BI will populate the data set list. If no data set has been created, you&#8217;ll get an error message.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-data-hub-option-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-data-hub-option-after-doing-power-bi-sumif.jpg\" alt=\"Click on Data Hub Option After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201cCreate report\u201d dropdown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-create-report-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-create-report-after-doing-power-bi-sumif.jpg\" alt=\"Click on Create Report After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add the Power BI Sankey Diagram Extension by ChartExpo, you\u2019ll have to create the Sankey Diagram using an add-in or Power BI visual from AppSource. Navigate to the right side of the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dashboards-design\" target=\"_blank\" rel=\"noopener\">Power BI dashboard<\/a>\u00a0and open the Power BI Visualizations panel. Click the ellipsis symbol (\u2026) to import the Power BI Sankey Diagram extension by ChartExpo. In the following menu that opens, select the \u201cGet more visuals\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-get-more-visuals-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-get-more-visuals-after-doing-power-bi-sumif.jpg\" alt=\"Select Get More Visuals After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Enter \u201cChartExpo\u201d in the highlighted search box. You\u2019ll see the \u201cSankey Diagram for Power BI by ChartExpo\u201d as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/enter-chartexpo-in-highlighted-search-box-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/enter-chartexpo-in-highlighted-search-box-after-doing-power-bi-sumif.jpg\" alt=\"Enter ChartExpo in Highlighted Search Box After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>After that, click on the Sankey Diagram and also click the highlighted &#8220;Add&#8221; button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-add-button-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-add-button-after-doing-power-bi-sumif.jpg\" alt=\"Click Add Button After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Power BI will add the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-sankey-diagram-icon-in-visualization-panel-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-sankey-diagram-icon-in-visualization-panel-after-doing-power-bi-sumif.jpg\" alt=\"Add Sankey Diagram Icon in VIsualization Panel After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To draw a Sankey Diagram with ChartExpo\u2019s Power BI extension, you\u2019ll have to select the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel. A window similar to the one below will open in the report section of your dashboard.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/open-in-report-section-of-your-dashboard-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/open-in-report-section-of-your-dashboard-after-doing-power-bi-sumif.jpg\" alt=\"Open in Report Section of Your Dashboard After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Follow the sequence below when selecting the fields to use in the Sankey chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/sekect-fields-to-use-in-sankey-chart-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/sekect-fields-to-use-in-sankey-chart-after-doing-power-bi-sumif.jpg\" alt=\"Sekect Fields to Use in Sankey Chart After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You\u2019ll have to provide your email address or the ChartExpo license key. Add the key under the Visual section. After that, the Sankey Chart will be displayed on your screen.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/provide-license-key-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/provide-license-key-after-doing-power-bi-sumif.jpg\" alt=\"Provide License Key After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the General section to add the top header text in the chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/navigate-to-general-section-after-doing-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/navigate-to-general-section-after-doing-power-bi-sumif.jpg\" alt=\"Navigate to General Section After Doing Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Here\u2019s the final look at the HR Dashboard in Power BI using ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-power-bi-sumif.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-power-bi-sumif.jpg\" alt=\"Final Power BI SUMIF\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MzUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p><strong>Insights:<\/strong><\/p>\n<ul>\n<li>Social Media has the highest number of candidates across all stages. That indicates strong outreach and high competition. Most candidates are knocked out in the initial screening stage.<\/li>\n<li>Across all channels, the ratio of candidates hired to the total candidates is relatively low, and that indicates a competitive selection process. It also shows high hiring standards.<\/li>\n<li>Direct channels and Employee Referrals have a lower proportion of candidates knocked out initially, and that indicates higher quality referrals (or direct applicants).<\/li>\n<\/ul>\n<h3>Improving Business Insights with Power BI SUMIF and Charts:<\/h3>\n<ol>\n<li>Open your Power BI Desktop or Web.<\/li>\n<li>From the Power BI Visualizations pane, expand three dots at the bottom and select \u201cGet more visuals\u201d.<\/li>\n<li>Search for \u201c<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MzUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Sankey Chart by ChartExpo<\/a>\u201d on the AppSource.<\/li>\n<li>Add the custom visual.<\/li>\n<li>Select your data and configure the chart settings to create the chart.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Share the chart with your audience.<\/li>\n<\/ol>\n<p data-pm-slice=\"0 0 []\">The following video will help you create a Sankey Chart in Microsoft Power BI using a <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey diagram maker<\/a>.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/_UyS9hzktr8?si=zkl8vEiizt8_NipC\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MzUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTczNSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"what-are-the-benefits-of-the-power-bi-sumif-function\">What are the Benefits of the Power BI SUMIF Function?<\/h2>\n<p>Here are some benefits of the Power BI SUMIF function:<\/p>\n<ul>\n<li>DAX library opens the users up to advanced Power BI features. For instance, the users can perform dynamic data manipulations through select, filter, join, and other commands.<\/li>\n<li>DAX helps to make Power BI Dashboards smart. This is done by implementing calculated columns, and Power BI Measures put constraints on the data fetched by the dashboard.<\/li>\n<li>DAX uses a collection of nested filter contexts to carry out performance optimization. Therefore, DAX functions help you build an optimal thinking pattern for creating tables and filtering data.<\/li>\n<\/ul>\n<h2>FAQs<\/h2>\n<h2>Is there a SUMIF function in Power BI?<\/h2>\n<p>Power BI doesn\u2019t come with a built-in SUMIF function like Excel. However, you can achieve similar functionality using DAX expressions like FILTER and SUMX.<\/p>\n<h3>How do you sum a column based on a condition in Power BI?<\/h3>\n<p>To sum a column based on a condition in Power BI, use DAX expressions like FILTER and SUMX. Specify the condition within the FILTER function to dynamically aggregate the data.<\/p>\n<h3>How do I sum all values in a column in Power BI?<\/h3>\n<p>The SUM function is used to sum all values in a column in Power BI. It is followed by the column name enclosed in square brackets ([]), like SUM([ColumnName]).<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>The Power BI SUMIF function is achieved through DAX expressions like FILTER and SUMX. It gives room for conditional aggregation, enhanced data analysis, and dynamic filtering. Users use it to extract insights from data.<\/p>\n<p>But why should you use the Power BI SUMIF function? Well, it opens you up to the world of advanced Power BI features. With the Power BI SUMIF function, you can perform dynamic manipulations like join, select, filter, and other commands.<\/p>\n<p>It also makes the Power BI dashboards smart. A correct DAX expression can optimize your latency and fulfill data processing tasks.<\/p>\n<p>Finally, your DAX experience sharpens your thinking and enables you to find better solutions when it comes to operations like filter, merge, and data manipulation.<\/p>\n<p>Now you know what the Power BI SUMIF function is, how will you incorporate it into your data analytic process?<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Discover the Power BI SUMIF function and its DAX equivalents. Improve reporting with conditional summation using CALCULATE &#038; FILTER for better insights.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-sumif\"><\/a><\/p>","protected":false},"author":1,"featured_media":46728,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Power BI SUMIF for Advanced Reporting -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/power-bi-sumif\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Power BI SUMIF for Advanced Reporting -\" \/>\r\n<meta name=\"twitter:description\" content=\"Discover the Power BI SUMIF function and its DAX equivalents. Improve reporting with conditional summation using CALCULATE &amp; FILTER for better insights.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce735-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI SUMIF for Advanced Reporting -","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:\/\/chartexpo.com\/blog\/power-bi-sumif","twitter_card":"summary_large_image","twitter_title":"Power BI SUMIF for Advanced Reporting -","twitter_description":"Discover the Power BI SUMIF function and its DAX equivalents. Improve reporting with conditional summation using CALCULATE & FILTER for better insights.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce735-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/power-bi-sumif","url":"https:\/\/chartexpo.com\/blog\/power-bi-sumif","name":"Power BI SUMIF for Advanced Reporting -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-01-29T15:33:35+00:00","dateModified":"2025-12-16T17:51:18+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/power-bi-sumif#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/power-bi-sumif"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/power-bi-sumif#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Power BI SUMIF for Advanced Reporting"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46711"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=46711"}],"version-history":[{"count":7,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46711\/revisions"}],"predecessor-version":[{"id":56940,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46711\/revisions\/56940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/46728"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=46711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=46711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=46711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}