Total sum not correct (measure in table again)

[JonGunnar]

Hi, I know this is a very common theme and even though I've been reading some of the articles I can't figure out how to solve this.

I'm recalculating some invoice lines due to change of price (using parameter), measures "Sum NO1 N" etc. Then I gather them in measure "Adjusted". Finally I want new total sum in Measure "New line amount". 

New line amount = IF([Adjusted] = BLANK(),CALCULATE(SUM('Spørring1'[LINE AMOUNT])),[Adjusted])

As you see my unchaged values are not included in "New line amount" total sum. I need the total to be correct. How to do this? And sorry for bringing this "total sum issue" up again.

Regards JG

[PaulDBrown · Accepted solution]

Try:
with totals = SUMX (Table, [New line amount])

[amitchandak]

@JonGunnar , You need to change measure like example

New line amount = sumx(summarize(Table, Table[Kanledar_kontraktna], Table[Year], Table[period], "_1",IF([Adjusted] = BLANK(),CALCULATE(SUM('Spørring1'[LINE AMOUNT])),[Adjusted])),[_1])

Correct the column name, and add un summarized column in summarize, if needed