Aggregated Functionality

[JanMachabee]

When ever I go to Sum up information I don't have the option to Aggregate it prior to Summing it up.

I somehow seem restricted us on how to use the field.  I seem to  always have to put a average of the current interest rate. Is there way to have information Aggregated in a Colum Prior to Summing it up?

Interest Rate Beyond Assumed Rate = if(average('Capital Cost Data'[CURRENT_INTEREST RATE]) < AVERAGE('Interest Rate Beyond Assumed Rate'[Interest Rate Beyond Assumed Rate]),0,  average('Capital Cost Data'[CURRENT_INTEREST RATE]) - AVERAGE('Interest Rate Beyond Assumed Rate'[Interest Rate Beyond Assumed Rate]))

Interest Payment Above Assumed Rate = [Interest Rate Beyond Assumed Rate] * sum('Capital Cost Data'[OUTSTANDING_BALANCE])

Its the last column that I want to have aggregated prior to doing the SUM

[amitchandak]

@JanMachabee , Not very clear.

But if you want correct GT , try measure like

Interest Payment Above Assumed Rate =

Sumx(Values([Table[ID Codes]), calculate( [Interest Rate Beyond Assumed Rate] * sum('Capital Cost Data'[OUTSTANDING_BALANCE]) )  )

or

New Interest Payment Above Assumed Rate  =

Sumx(Values([Table[ID Codes]), [Interest Payment Above Assumed Rate ]  )