SUMX for aging data not working

[sjehanzeb]

I have created an aging formula for an education institution. the aging is calculating correctly. though the total figures are incorrect
there are three tables in use, the main Date table (sf), a calender table (calender) and mapping table for main data table (mapping).

Aging 0-60 = 
var agingto=0
var agingfrom=60
var totatoutstanding=sum(SF[Line Amt])
var maxdate = LASTDATE(Calender[Date])
var positivevalues = CALCULATE(sum(SF[Line Amt]), FILTER(sf, SF[Itm Eff Dt_6]>DATEADD(maxdate, -agingfrom, DAY) && SF[Itm Eff Dt_6]<=DATEADD(maxdate, -agingto, DAY)), Mapping[Transaction ]="Fee - Adjustable" || Mapping[Transaction ]="tax" || Mapping[Transaction ]="Fee", SF[Line Amt]>0)
var previousaging=0
var result = MIN(SUM(SF[Line Amt])-previousaging, positivevalues)
return
if(HASONEFILTER(SF[ID]), 
if (result=0, BLANK(), result), sumX(sf, result))

[sjehanzeb]

Thanks. Your solution worked. 
though can you explain why it needed to reference it again and can I resolve this using one measure

[mahoneypat · Accepted solution]

Please try this expression.  Replace Table with your actual table name and use this measure in place of your current one (which it references).

NewMeasure = SUMX(VALUES(Table[ID]), [Aging 0-60])

Regards,

Pat