Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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)
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 🙂