Forum Discussion
Table Sum is incorrect.
if I were to take out my first 'if' statement "(if(value1-value2 <= 0, 0,)" the value comes out to be -92. But I'm replacing its value with 0. So why is calculating with the -92.
PowerBI tables/matrixes don't sum up the same way that Excel does. Instead it recalculates the measure in the current context, which is ignoring the DLIN, DSUB, etc context. It is calculating in the "Louisiana-Customer View" context.