Forum Discussion
Solved
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...
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
Hi Simondeb ,
You could use ISINSCOPE() fcuntion to custom your total row.
Measure =
IF(ISINSCOPE('Table'[Areas]),Your original formula,Your new formula)