cancel
Showing results for
Did you mean:
Helper I

## 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 row every time

Any help is much appreciated

Test = CALCULATE( SUM( Table[Value]), Table[Code] = Table[Code] )

 Code Value Actual Response Required Response A 2 2 6 A 2 2 6 A 2 2 6 B 2 2 4 B 2 2 4 C 2 2 8 C 2 2 8 C 2 2 8 C 2 2 8 D 2 2 4 D 2 2 4
1 ACCEPTED SOLUTION
Super User

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] ) )``````
4 REPLIES 4
Super User

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] ) )``````
Helper I

@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() ??

Helper I

I got past this by adding another column that gives the MAX result. Ideally I'd like to avoid having 2 columns

Responsive Resident

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

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

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!