Forum Discussion
Issues with CALCULATE (SUM)
Hi, I'm trying to get a columbn to SUM all the values for a given code, in every row that code is in. See below example But the issue is my formula I'm using keeps giving just the SUM of the one ...
Here are a couple of additional alternatives:
Test = VAR _Code = Table[Code] RETURN CALCULATE ( SUM ( Table[Value] ), Table[Code] = _Code )Test = CALCULATE ( SUM ( Table[Value] ), ALLEXCEPT ( Table, Table[Code] ) )
DimaMD thanks - that works for some, but a lot of the codes are adding up as they go, so onlt the last code in the table has the full total - Is there a better function that EARLIER() ??
I got past this by adding another column that gives the MAX result. Ideally I'd like to avoid having 2 columns