Forum Discussion

csrapp96's avatar
csrapp96
Helper I
2 years ago
Solved

Average of Multiple Growth Rates

Hello PBI Community, I found a way to average the values across my table and come up with a total average growth rate. But I need the average of the growth rates for each line item. I can't find a...
Need Help
  • csrapp96's avatar
    csrapp96
    2 years ago

    I solved it! 

    I needed to use the AVERAGEX(Summarize(Summary,Summary[Team], [Growth Measure])

    This in effect groups the team measures and then finds the average of them 🙂

csrapp96's avatar
csrapp96
Helper I
2 years ago

Thanks! It gets me to the average for each line. 

RETURN CurrentYearSales is correct
RETURN PreviousYearSales is correct

but 

RETURN AVERAGEX(...... (CurrentYearSales - PreviousYearSales) / PreviousYearSales ) is calculating as "Infinity"

 
As a check, RETURN (CurrentYearSales-PreviousYearSales) doesn't calculate correctly either.

I'm playing around with it and feel like it's close but still not quite right.

Thank you

csrapp96's avatar
csrapp96
Helper I
2 years ago

I solved it! 

I needed to use the AVERAGEX(Summarize(Summary,Summary[Team], [Growth Measure])

This in effect groups the team measures and then finds the average of them 🙂