Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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] ) )
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
hi @michaelmichael If you use this in the count column, try this code
CALCULATE(SUM('Лист1'[Value]),'Лист1'[Code] = EARLIER('Лист1'[Code]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |