CAGR * Columns

[jaswalsarthak]

Hi All, i have 5 years of data & have got Dynamic CAGR (% format) into my Dashboard. Now i want to multiply this CAGR with my table. i am using the below formula.

CAGR Sale = SUMX(Table1,Table1[Value]*Table1[CAGR Value])

 Its Not working.

i have tried the below one too,still its not woking 

CAGR Sale = SUMX(Table1,Table1[Value]*Value(Table1[CAGR Value]))

Please Help

[sjoerdvn]

Like @Anonymous wrote it is hard to solve this without more information, but you try adding a CALCULATE to the second SUMX argument, so SUMX(Table1,CALCULATE(

[Anonymous]

Hi, @jaswalsarthak 

Thanks for rajendraongole1 reply. After testing, it didn't reproduce your problem, You can simulate a pbix file with simple, non-sensitive data for testing purposes. it will help you to solve the problem faster.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[jaswalsarthak]

Hi I am not looking to calculate CAGR, that i have already done, i want to multiply CAGR with my table & that is not working.

[rajendraongole1]

Hi @jaswalsarthak - Ok, then make sure your CAGR value is correctly calculated as like below:

CAGR Value =
(
(SUM(Table1[Value]) / FIRSTNONBLANK(Table1[Value], 0)) ^
(1 / COUNTROWS(DISTINCT(Table1[Year])))
) - 1

If CAGR Value is a measure and not a column, you would need to modify the calculation

CAGR Sale =
SUMX(
Table1,
Table1[Value] * [CAGR Value]
)

Hope this helps.

[rajendraongole1]

Hi @jaswalsarthak -please find the solved solutions on CAGR

Solved: CAGR - Microsoft Fabric Community

Solved: Calculate CAGR values - Microsoft Fabric Community

Solved: CAGR for multiple periods - Microsoft Fabric Community

https://community.fabric.microsoft.com/t5/Desktop/CAGR-computation/m-p/3219863

Hope this helps.