Column = SUM ( Order[Price] ) has row context with a calc column but still grabs total sum

[brs09j]

I watched Marco's video but still don't get this.

I tried switching this to a SUMX and still got the same result.

I thought the row context was being established by the calculaed column and aggregator? What am I missing here.

[Anonymous · Accepted solution]

When you are calculating a single row, the context is that single row.  Thus if you do a "SUM" on a column of the current table, you will only be summing up 1 rows worth of values.

Instead you might want to use a calculate statement and provide a filter context.  For example, this would give you a sum total of all of the prices where each row has the same location value.  (I have no idea why you would do that, but i hope it illustrates the point).

Column = 
VAR LocationValue = [Location]
RETURN
CALCULATE(
	SUM ( Order[Price] ),
	ALL ( Order ),
	Order[Location] = LocationValue
)