Forum Discussion
Tevon713
Helper V
Helper Vsum value if less than 0
Hi.
Trying to sum a data field only if the sum of it is < 0 else do not sum it or return 0. IF statement or filter be best. I have over 3M records.
For example.
| Acct # | Count |
| 999727 | 1 |
| 999727 | -2 |
| 992592 | 0 |
| 992035 | 1 |
| 992035 | -2 |
| 986977 | -2 |
| 986977 | 2 |
| 936300 | -1 |
Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN CALCULATE([Sum Count],_tbl) or Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN sumx(_tbl,[SUM])
3 Replies
- Ahmedx
Super User
CALCULATE(SUM('tabl'[Count]),'tabl'[Count]<0)
Tevon713Thanks but didn't yield the answer I'm wanting. Sum only if the sum of the count is <0.
Sum Count = SUM(Data[Count])Sum count 1 = CALCULATE(SUM(Data[Count]), Data[Count]<0)
- Ahmedx
Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN CALCULATE([Sum Count],_tbl) or Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN sumx(_tbl,[SUM])