Sum of values per parameter

[Anonymous]

Hi! I have a table: 

person_id	value
1022	0
1022	0
1022	0
1022	1
1022	0

And so on, so it is a column, where we have 5 values per one person, I need a column that will show the sum of those 5 values per person, so it will look like this:

person_id	value	sum
1022	0	1
1022	0	1
1022	0	1
1022	1	1
1022	0	1

What dax formula I need to create a column "sum"

[Fowmy · Accepted solution]

@Anonymous 

Please use the following measure 

M = 

CALCULATE (
    SUM( Table[Value]),
    ALLEXCEPT ( table , table[person id])
)

[Anonymous]

Thanks a lot

[Jihwan_Kim]

Hi,

Please try the below to create a new column.

Sum CC =
SUMX (
    FILTER (
        'TableName',
        'TableName'[person_id] = EARLIER ( 'TableName'[person_id] )
    ),
    'TableName'[value]
)

[daXtreme]

Is this to be a measure or a calculated column? If a calc column...

[Sum] = // calc column
var vPerson = T[person_id]
var Result =
    SUMX(
        filter(
            T,
            T[person_id] = vPerson
        ),
        T[value]
    )
RETURN
    Result