not getting the same result in this formula

[Easley08]

Hi, 

is there a way to compute this 

BASE RATE * INCREASE RATE * NO_OF INCREASE

13500*1.035*1.035*1.035 

= 14,968

but in my table i have this

i used this formula 

= (SUM(base rate) * sum(increase rate)) * sum(no_of increase)

 even i use this formula 

= (SUM(base rate) * values(increase rate)) * values(no_of increase)

 = 41,917

[Anonymous · Accepted solution]

Hi @Easley08 ,

I think you can try POWER() funtion to have a try.

Measure = 
CALCULATE(SUM('Table'[base rate])* POWER(SUM('Table'[increase rate]),SUM('Table'[no_of increase])))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

could you expand your data sample with your expected result?