# Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. You may watch the full video of this tutorial at the bottom of this blog.

The technique that I’m going to go through can be replicated in many different scenarios, so don’t get too caught up in this specific one. I want you to focus on understanding and learning the Power BI DAX formula that you need to use.

In this example, I calculate the profits of a company, and I want to see the growth over time. I want to be able to represent that in a scatter chart that allows me to see the clustering of good-performing, average-performing, and poor-performing stores.

Moreover, I want it to be represented in a spatial way to identify any clusters in a particular region.

## Measure Branching With Power BI DAX Formula

The key technique here is measure branching, which uses a core Power BI DAX formula to create more measures. In other words, we start with simple calculations, then we build calculations that represent those formulas.

This example is a demo resource that was from a Learning Summit in Enterprise DNA. In this case, I needed to work out the Profit Difference. As you can see, this formula is purely just referencing measures, Total Profits and Profits LY (last year).

The formula for Profits LY is also quite simple. It uses a time intelligence function, SAMEPERIODLASTYEAR.

These results in the visualizations will update depending on whatever time context I input.

## Working Out Profit Growth Versus Last Year

Once I have the Profit Difference, I work out the Profit Growth versus Last Year. The formula simply calculates by subtracting Profits LY from Total Profits, and then divide it by the Profits made last year.

So if the profits this year are exactly the same as the profits made last year, there’s zero growth.

## Using Supporting Tables

I didn’t want to only show all these results in just a scatter chart because it doesn’t really provide that much information. The results can be represented in a more effective way. This is where this dynamic grouping technique really comes in. I wanted to be able to visualize who were the best growth areas or states versus some of the lowest ones.

To achieve this, I utilized a supporting table to create these groupings.

I’ve created this by going to Enter Data; here I just input all of these figures (Min and Max) to represent the groups, High, Average, Low, and No Growth.

## Pattern Recognition DAX Formulas

To get these groups represented on this visualization, I utilize a more advanced Power BI DAX formula. This formula breaks up the States based on the result. It works through each State with VALUES function. For each State, it works out the Profit Growth vs LY to see what group it is in.

If that particular State equates to true in a particular group, it gets associated to that particular group based on this visualization.

So this Performance Group actually comes from that supporting table that I created.

I did exactly the same with the other formula. The only difference is that this is representing Profit Difference.

I can change to any time frame here and it updates and maintains the groupings based on the outlines of the groups that I created in the supporting table.

## Conclusion

This technique around Power BI DAX formula is a really effective and dynamic way to visualize any growth metrics over different periods. I think consumers would love seeing data in this way.

I hope you got a lot out of this tutorial. Measure branching is quite advanced, but it’s such a great technique. I also demonstrated some segmentation and visualization techniques with DAX, so hopefully you got a lot out of it and utilize them in your own models.

Cheers!

Sam

Sam McKay, CFA
Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data driven cultures and create enterprise value by delivering business intelligence training and education.

## Matrix Visualization In Power BI

I will show you formatting tricks on how to put think borders on matrix visualizations in Power BI....

## Power Query Each Expression: An Introduction

Power Query is a data transformation and manipulation tool that's available in Microsoft Excel and...

## VertiPaq Analyzer In DAX Studio | Power BI Tutorial

This tutorial will showcase the VertiPaq Analyzer Metrics in DAX Studio and how it helps in optimizing...

## Convert The Date Table Function Into A Table Query In Power BI

I'm going to show you how to turn an M code for a date table into a table query. You may watch the full...

## Creating Power BI Tables By Using UNION & ROW Function

I'm going to show you how you can create Power BI tables using a formula that combines the UNION...

## Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this...

## Power BI Slicers Tutorial: Counting Selections Correctly

In today's tutorial, I'm going to work through a subtle issue with Power BI slicers that can trip you...

## Rule Of Thirds: The Composition Rules

When it comes to presenting the story, we need to start with the layout. This is where the rule of...

## Tips For A Successful Power BI Implementation

We'll continue our series on Power BI project planning and implementation. This time around, we'll be...

## PowerApps Documentation: Using MS Docs For Expert Functionalities

Let's talk about Microsoft's PowerApps documentation and what an important resource it can be for users...

## Predicting When Will Your Customers Purchase Next w/Power BI

What if you could know when your customers are likely to make their next purchase using predictive...

## Power BI Challenge 14 – Emergency Services Analytics

We've been very busy here at Enterprise DNA as we continue to level up our content so that all of you...