Tag: SUMX DAX

The Difference Between SUM vs SUMX In Power BI

SUM vs SUMX What's The Real Difference Between These DAX Measures

There is still a lot of confusion about the difference between SUM vs SUMX in Power BI. This is key knowledge that users have to master because both functions can be used across different scenarios, but there are cases where one is more efficient than the other. You may watch the full video of this

Continue reading

Advanced Tips To Optimize Your Power BI Table

This tutorial showcases some advanced tips to optimize your Power BI table. I’ll show you how to break out your large table into multiple ones. This concern is quite common across legal database systems with huge flat files of information. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

How To Use Iterating Functions To Fix Total Issues In Power BI – DAX Concepts

How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts

I’m going to show you today how to use iterating functions when you’re trying to fix Total issues in Power BI. You may watch the full video of this tutorial at the bottom of this blog. When I go through the questions posted on the Enterprise DNA support forum for members, I see a lot

Continue reading

Using Iterating Functions SUMX And AVERAGEX In Power BI

One of the most crucial topics for any Power BI beginner to know about is iterating functions. You may watch the full video of this tutorial at the bottom of this blog. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article.

Continue reading