Forum Discussion
Sum total lines
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
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
3 Replies
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
It works perfectly, thanks 🙂
Hi Simondeb ,
You could use ISINSCOPE() fcuntion to custom your total row.
Measure = IF(ISINSCOPE('Table'[Areas]),Your original formula,Your new formula)
