Tag: CALCULATE function

A Deeper Understanding Of Advanced RANKX

Advanced RANKX - How To Understand This Function More Deeply

This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also

Continue reading

How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique

How To Compare Two Lists Of Calculated Data Virtually - Advanced DAX Technique

When working with calculated data, comparing different data sets will sometimes be necessary. I’m going to show you how to do that by combining different table functions. The INTERSECT function is the best thing to use in cases like these. Some may also say that EXCEPT is just as useful in comparing calculated data. But

Continue reading

Creating A Pareto Chart In Power BI – Advanced DAX

Creating A Pareto Chart In Power BI - Advanced DAX

This blog tutorial showcases a really interesting example around Pareto analysis. I’m going to teach you how to create a Pareto chart using advanced DAX formulas. I’ll show you how to use a combination of formulas to be able to generate a visualization like this one. The first thing that I always recommend when working

Continue reading

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Conditional formatting is a way of visualizing data by applying a certain set of format rules based on user-defined conditions. For Power BI visuals, it is mostly used when presenting data in a tabular form. In this tutorial, I’ll discuss how to combine DAX formulas with the new conditional formatting feature to highlight the last

Continue reading

Dynamically Calculate A Power BI Running Total Or Cumulative Total

The Power BI running total is the perfect way to display patterns and changes on a specified data over time. In Power BI, there is a common combination of DAX functions that allow us to create a dynamic cumulative total on any report page. The DAX formula that we’re about to discuss is easy to

Continue reading