Sum total lines

[Simondeb]

Dear All,

I have a problem on y table, I calculated Price effect / Mix Effect Volume effect in a table.

it's well calculated lini by line but i want the total to be the sum of my line instead of recalculating my affect on the total.

I want the total line to be -1832 / +2254 / -13139

How can I do that??

Thank you,

Regards, Simon

[v-eachen-msft]

Hi @Simondeb ,

You could use ISINSCOPE() fcuntion to custom your total row.

Measure = 
IF(ISINSCOPE('Table'[Areas]),Your original formula,Your new formula)

[amitchandak · Accepted solution]

@Simondeb ,

You have to do something like this

sumx(summarize(Table,Table[Area],table[Sub Area],"_for",[Measure]),[_for])

Sub Area is there second row(Group by) in table

Measure the one you looking to correct the calculation

[Simondeb]

It works perfectly, thanks 🙂