{"id":178005,"date":"2024-02-22T15:28:37","date_gmt":"2024-02-22T14:28:37","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178005"},"modified":"2024-02-09T16:19:25","modified_gmt":"2024-02-09T15:19:25","slug":"sumx-power-bi-whats-it-all-about-and-how-to-use-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it","title":{"rendered":"Sumx Power BI: what&#8217;s it all about and how to use it?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178005\" class=\"elementor elementor-178005\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bff650e e-flex e-con-boxed e-con\" data-id=\"bff650e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-207ebbd elementor-widget elementor-widget-text-editor\" data-id=\"207ebbd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>Power BI&#8217;s SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative function, and how to take a Power BI training course!<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8731b5 elementor-widget elementor-widget-text-editor\" data-id=\"e8731b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/the-evolution-of-data-insights-data-science-vs-business-intelligence-in-the-big-data-era\">Microsoft&#8217;s Business Intelligence<\/a> and Data Visualization tool, Power BI, is a resounding success in the enterprise. This software is transforming the way data analysis is used to solve business problems.<br \/>Power BI makes it easy to work with data. Its real-time analysis, modeling and customization features open up a wealth of possibilities.<\/p><p>What&#8217;s more, the DAX (Data Analysis Expressions) language brings together functions, operators and constants used to create formulas and <strong>expressions in Power BI.<\/strong><\/p><p>These mathematical functions reveal the full value of your data. One of the most important Power BI functions is SUMX<strong>, used to obtain the<\/strong> sum of expressions in a table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-62d77f8 e-flex e-con-boxed e-con\" data-id=\"62d77f8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e0e83c0 elementor-widget elementor-widget-heading\" data-id=\"e0e83c0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">What is Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f7132ae elementor-widget elementor-widget-text-editor\" data-id=\"f7132ae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Power BI is a Business Intelligence and <a href=\"https:\/\/datascientest.com\/en\/dataviz-definition-objectives-and-uses\">Data Visualization platform<\/a> developed by Microsoft. It enables organizations to analyze data and generate reports based on the results.<\/p><p>The platform brings together a wide range of tools, applications and connectors for extracting actionable information from data, creating immersive visuals and interactive reports.<\/p><p>In fact, <a href=\"https:\/\/datascientest.com\/en\/power-bi-tooltips-discovering-the-tooltip-and-its-use-cases\">Power BI is a self-service Business Intelligence tool.<\/a> This means that data can be aggregated, analyzed and visualized very easily to produce compelling reports.<\/p><p>Data from multiple sources such as <a href=\"https:\/\/datascientest.com\/en\/oracle-the-challenger-rivaling-azure-aws-and-google-cloud\">Oracle<\/a>, SAP or the data warehouse of your choice can be collected using Power BI. This platform can handle anything from a single Excel file to a vast volume of Big Data.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-94a8970 elementor-widget elementor-widget-image\" data-id=\"94a8970\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/160-power-bi-logo.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34bea8a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"34bea8a\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Find out more about Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-93513fb e-flex e-con-boxed e-con\" data-id=\"93513fb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f809de0 elementor-widget elementor-widget-heading\" data-id=\"f809de0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the strengths of Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0caccf elementor-widget elementor-widget-text-editor\" data-id=\"b0caccf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Power BI<\/strong> has proven itself as a reliable and intuitive tool for data analysis and visualization. Its immense popularity is linked to several strong points.<\/p><p>Firstly, its multiple connectors enable data to be extracted from a wide variety of sources. In addition, teams can share access to reports in a secure and controlled way.<\/p><p>Another strength of Power BI is the ability to display real-time data and visuals in any report or dashboard.<a href=\"https:\/\/datascientest.com\/en\/dashboard-what-is-it\"> Dashboards are updated in real time,<\/a> enabling problems to be solved and new opportunities discovered instantly.<\/p><p>The platform also offers a wealth of customization possibilities, allowing users to tap into its catalog to create visualizations to suit their needs. Custom visualizations can also be generated using <a href=\"https:\/\/datascientest.com\/en\/google-data-studio-introduction-to-googles-dataviz-tool\">DataViz modules in the R and Python languages.<\/a><\/p><p><a href=\"https:\/\/datascientest.com\/en\/artificial-intelligence-definition\">Thanks to the artificial intelligence features<\/a> added in recent updates, users can use techniques such as image recognition or text analysis to prepare data, develop Machine Learning models, and rapidly extract actionable information.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cae8d45 e-flex e-con-boxed e-con\" data-id=\"cae8d45\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e471d7 elementor-widget elementor-widget-heading\" data-id=\"4e471d7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is SUMX?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b1642e elementor-widget elementor-widget-text-editor\" data-id=\"3b1642e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\">Power BI&#8217;s DAX (Data Analysis Expressions) language<\/a> brings together over 200 functions, operators and constants, offering great flexibility for data analysis tasks.<\/p><p>The iterative SUMX function calculates all the rows in a table and returns the sum of the products. In this way, it first calculates the product of each field&#8217;s values before adding them together.<\/p><p>All iterative functions apply the calculations to each row one by one. Other Power BI iterative functions include COUNTX, RANKX and PRODUCTX.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db286fd elementor-widget elementor-widget-image\" data-id=\"db286fd\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/fonction_iteratives_sumx.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-990aeb6 e-flex e-con-boxed e-con\" data-id=\"990aeb6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-72b33b3 elementor-widget elementor-widget-heading\" data-id=\"72b33b3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SUMX syntax<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5937e90 elementor-widget elementor-widget-text-editor\" data-id=\"5937e90\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In terms of syntax, a typical SUMX function takes this form: SUMX (&lt;Table&gt;, &lt;Expression&gt;).<\/p><p>The &#8220;Table&#8221; parameter indicates the name of the table to which the <strong>DAX SUMX function<\/strong> is applied. Steps or iterations will be performed on the rows of this table.<\/p><p>The &#8220;Expression&#8221; parameter is the expression or equation to be evaluated on each line. The result of the sum is returned as a SCALAR value.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-280a45b e-flex e-con-boxed e-con\" data-id=\"280a45b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5aea579 elementor-widget elementor-widget-heading\" data-id=\"5aea579\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use SUMX in Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cde25c7 elementor-widget elementor-widget-text-editor\" data-id=\"cde25c7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Applying the<strong> SUMX function to Power BI<\/strong> is very simple. After loading the dataset and naming the table, simply right-click on the table and choose &#8220;New Measure&#8221;.<\/p><p>Name the measure as you like, open the SUMX function and specify the name of the table and the expression to be evaluated. Close the brackets and parentheses and press the &#8220;Enter&#8221; key to obtain the result.<\/p><p>To view the results, click on the &#8220;Report&#8221; tab and select from the list of views. Drag the appropriate fields into the &#8220;Values&#8221; tab to obtain the sum table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a21635 elementor-widget elementor-widget-image\" data-id=\"3a21635\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"439\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/umap.webp\" class=\"attachment-large size-large wp-image-173175\" alt=\"umap\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/umap.webp 1024w, https:\/\/datascientest.com\/en\/files\/2023\/11\/umap-300x165.webp 300w, https:\/\/datascientest.com\/en\/files\/2023\/11\/umap-768x422.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-da072a0 e-flex e-con-boxed e-con\" data-id=\"da072a0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bf6bf9b elementor-widget elementor-widget-heading\" data-id=\"bf6bf9b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What's the difference between SUMX and SUM?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65c3bf8 elementor-widget elementor-widget-text-editor\" data-id=\"65c3bf8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>It&#8217;s essential to understand the difference between the SUM and SUMX functions in Power BI. Learning how to use these functions correctly enables you to dive deeper into raw data and extract actionable information with ease.<\/p><p>Using these functions takes the complexity out of analysis, and reveals the full potential of the data. Although they may seem similar, these two functions are quite different.<\/p><p><a href=\"https:\/\/datascientest.com\/en\/power-bi-matrix-table-how-to-use-this-feature\">Power BI<\/a> has two basic calculation engines: the aggregation engine and the iteration engine. The DAX SUM function is linked to the aggregation engine and adds up all the values in a single column to return the result.<\/p><p>It considers a single column as a whole and returns a result. Aggregation functions cannot perform evaluations on every row of a table.<\/p><p><strong>SUMX,<\/strong> on the other hand, is an iterative function with a different approach. It can perform calculations row by row, and iterates over each row of a specified array to complete the calculation. The results of each row are then added together.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7c65c4c e-flex e-con-boxed e-con\" data-id=\"7c65c4c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cce4215 elementor-widget elementor-widget-heading\" data-id=\"cce4215\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to choose between SUMX and SUM?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e9cfe0 elementor-widget elementor-widget-text-editor\" data-id=\"6e9cfe0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>function SUMX<\/strong> can be used whenever a row-by-row calculation is required. If the data is structured in such a way that it is necessary to multiply the values of two columns one row at a time, this function must be used.<\/p><p>In addition, <strong>SUMX<\/strong> can also operate on a single column. It is therefore theoretically possible to use SUMX as a simple aggregator, thanks to its iterative nature. However, this function consumes more resources than SUM, and can have a negative impact on dashboard performance.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b74c882 elementor-widget elementor-widget-image\" data-id=\"b74c882\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/SUM-vs-SUMX.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9bbcee elementor-widget elementor-widget-text-editor\" data-id=\"a9bbcee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Function SUM, on the other hand, can be used for all single-column calculations and when line-by-line execution is not required. If data is structured to contain a single column of values, function SUM can be used to sum the values. This function operates on a single column, and therefore does not require an iterator.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-499a20b e-flex e-con-boxed e-con\" data-id=\"499a20b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7303736 elementor-widget elementor-widget-heading\" data-id=\"7303736\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How to master Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3335ec8 elementor-widget elementor-widget-text-editor\" data-id=\"3335ec8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Data professionals around the world use Microsoft Power BI to examine data from multiple sources and create compelling charts, dashboards and reports.<\/p><p>The tool&#8217;s features make it easy to import, transform and visualize data to create high-quality reports. However, mastery of both <a href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\">DAX and SUMX functions is required to take full advantage of the data.<\/a><\/p><p>If you want to learn how to fully master Power BI and its more subtle functions, you can choose DataScientest. Our Power BI training course enables you to master the platform in just 38 hours over five days.<\/p><p>As a Microsoft Learning Partner, DataScientest can prepare you to take the official <strong>PL-300 certification<\/strong> to become a Microsoft Power BI Data Analyst Associate.<\/p><p>Alternatively, beginners can take the Power BI Dashboarding course. This 24-hour course, spread over three days, teaches how to use tools such as DAX and Power Query to analyze data and create dashboards with Power BI.<\/p><p>Conversely, those who are already familiar with Power BI can opt for the Advanced course. This 14-hour course, spread over two days, uncovers all the secrets of the tool, including DataFlows and Incremental Refresh.<\/p><p>As far as financing is concerned, DataScientest is eligible for different funding options. Don&#8217;t wait any longer, and discover Power BI training!<\/p><p>You&#8217;ll know everything there is to know about the <strong>Power BI SUMX function.<\/strong> For more information on the same subject, take a look at our complete dossier on Power BI and our dossier on its <a href=\"https:\/\/datascientest.com\/en\/dax-studio-everything-you-need-to-know-about-the-dax-language-query-analysis-tool\">DAX language.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20db68c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"20db68c\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Find out more about our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-92cf948 e-flex e-con-boxed e-con\" data-id=\"92cf948\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-47a0dae elementor-widget elementor-widget-html\" data-id=\"47a0dae\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is Power BI?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Power BI is a Business Intelligence and Data Visualization platform developed by Microsoft. It enables organizations to analyze data and generate reports from the results.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What are the strengths of Power BI?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Power BI has proven itself as a reliable and intuitive tool for data analysis and visualization. Its immense popularity is linked to several strong points.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the SUMX function?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Power BI's DAX (Data Analysis Expressions) language brings together more than 200 functions, operators and constants offering great flexibility for data analysis tasks.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Power BI&#8217;s SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative function, and how to take a Power BI training course! Microsoft&#8217;s Business Intelligence and Data Visualization tool, Power BI, is a resounding success in the enterprise. This software [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178006,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sumx Power BI: what&#039;s it all about and how to use it?<\/title>\n<meta name=\"description\" content=\"Power BI&#039;s SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sumx Power BI: what&#039;s it all about and how to use it?\" \/>\n<meta property=\"og:description\" content=\"Power BI&#039;s SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-22T14:28:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-09T15:19:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/02\/SUM-X-POWER-BI.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"404\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Sumx Power BI: what&#8217;s it all about and how to use it?\",\"datePublished\":\"2024-02-22T14:28:37+00:00\",\"dateModified\":\"2024-02-09T15:19:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\"},\"wordCount\":1280,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\",\"url\":\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\",\"name\":\"Sumx Power BI: what's it all about and how to use it?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-02-22T14:28:37+00:00\",\"dateModified\":\"2024-02-09T15:19:25+00:00\",\"description\":\"Power BI's SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Sumx Power BI: what's it all about and how to use it?","description":"Power BI's SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative","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:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it","og_locale":"en_GB","og_type":"article","og_title":"Sumx Power BI: what's it all about and how to use it?","og_description":"Power BI's SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative","og_url":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-02-22T14:28:37+00:00","article_modified_time":"2024-02-09T15:19:25+00:00","og_image":[{"width":1024,"height":404,"url":"https:\/\/datascientest.com\/en\/files\/2024\/02\/SUM-X-POWER-BI.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Sumx Power BI: what&#8217;s it all about and how to use it?","datePublished":"2024-02-22T14:28:37+00:00","dateModified":"2024-02-09T15:19:25+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it"},"wordCount":1280,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it","url":"https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it","name":"Sumx Power BI: what's it all about and how to use it?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-02-22T14:28:37+00:00","dateModified":"2024-02-09T15:19:25+00:00","description":"Power BI's SUMX function calculates the sum of the products of all the rows in a table. Find out everything you need to know about this iterative","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sumx-power-bi-whats-it-all-about-and-how-to-use-it"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178005"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=178005"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178005\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178006"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}