Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
4 years ago

hi Anonymous  If you use this in the count column, try this code

CALCULATE(SUM('Лист1'[Value]),'Лист1'[Code] = EARLIER('Лист1'[Code]))