Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mothert
New Member

Growth Rate Measure that SUMS Growth Rate Column instead of calculating Total Row

Hi,

I am new to Power BI and DAX. I am trying to calculate a simple 3-year growth rate like  this example from excel:

Age201820192020Growth Rate
<= 20634-33.33%
21-257111157.14%
26-30755-28.57%
31-403230.00%
41-50110-100.00%
51-600000.00%
61 >  0000.00%
Total242223-4.17%

 

However when I do this in Power BI and create a measure using the following:

Growth Rate = DIVIDE( [2020]-[2018], [2018], BLAK())

It sums the Growth rate column Total row, instead of calculating the growth rate for the Total row. See image:

GR.PNG

I don't want -104.76% I want it to calculate the growth rate for the 'Total' row.

 

Any ideas?

 

Thanks,

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Picture1.png

 

Growth Rate: =
DIVIDE ( SUM ( Data[2020] ) - SUM ( Data[2018] ), SUM ( Data[2018] ) )
 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

 

Picture1.png

 

Growth Rate: =
DIVIDE ( SUM ( Data[2020] ) - SUM ( Data[2018] ), SUM ( Data[2018] ) )
 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


@Jihwan_Kim  That worked! Thank you!

 

 

amitchandak
Super User
Super User

@mothert , Ideally power bi should give you the same answer as excel(what you shown) . I doubt you have something on top of this measure. By default grand totals are recalculated in power bi

The other chart (the color one) is what is happening in Power BI. The measure I created used the formula I mentioned above:

Growth Rate = DIVIDE( [2020] - [2018], [2018]. Blank())
It gives me what you see in the color chart.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors