Tag: DAX Functions

How To Use The COUNTROWS DAX Function In Virtual Tables

I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see

Continue reading

Using AVERAGEX In Power BI – A DAX Tutorial & Examples

Using The AVERAGEX Function - DAX Tutorial & Examples

AVERAGEX in Power BI is an incredibly versatile function. It’s not just for averaging values; it’s also great for trend analysis. I discussed the use of AVERAGEX for trend analysis in the Enterprise DNA Learning Summit. A link to the event can be found below. But in this post, I’m going to focus more on

Continue reading

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. I’m going to focus on one example here

Continue reading

Using ALLEXCEPT To Stop The Cumulative Total From Resetting

I’m going to go through an interesting scenario that you’ll probably land on when you’re trying to run a Cumulative Total inside of Power BI.  A member from the Enterprise DNA support forum posted this query. The member wanted to calculate a running balance like a Cumulative Total. The problem was every time a selection

Continue reading

Dynamically Calculating The Previous Highest Result Using DAX Functions

DAX functions greatly expand dynamic calculations. They also broaden the other important capabilities in Power BI.  In this tutorial, we’ll discuss how you can dynamically calculate the previous highest result in Power BI. We’ll also be learning the right combination of formula and techniques for this particular calculation. By doing a dynamic calculation, we can

Continue reading