What is the difference between SUM() and SUMX()?

WHAT IS THE DIFFERENCE BETWEEN SUM() AND SUMX()?

What is the difference between SUM() and SUMX()? When I first started using Power BI and was learning DAX, I always asked myself when to use SUM() and SUMX(). This is explained in an easy language.

SUM() and SUMX()

more blog posts

HOW TO FIND THE HERO IN YOUR DATA STORY?DIFFERENT TECHNIQUES TO TELL YOUR DATA STORYVast amounts of data are captured daily in every organization. To use data to change the direction of your business strategy or make the right decisions,…

WHAT IS THE DIFFERENCE BETWEEN SUM() AND SUMX()? What is the difference between SUM() and SUMX()? When I first started using Power BI and was learning DAX, I always asked myself when to use SUM() and SUMX(). This is explained…

How to pivot text data? If you are curious to know how to pivot text data through Power Query in Power BI, have a look at the great post written by Matt Allington. Pivoting text data more blog posts How…

How to group without DAX? There are several ways in Power BI Desktop to group text or numbers. If you are curious how you can make use of the grouping feature without writing any DAX, you should definitely read this.…

How to make the right decisions and let experience not mislead you How can we trust our past experiences in order to predict the future and make decisions? Experience can also fool us instead of being a reliable teacher.  When we want…

How to connect Power BI with the Cognitive Services and Text Analytics API?   You can visualize and transform your data with Microsoft Power BI Desktop. In order to analyze natural language processing we will make use of the Text…