Calculated Column with SUM in same Table and two Filters

[joshua1990]

Hi experts!

I have a table like this:

Date	Article	Department	Value
01.01.2023	A	1	5
01.01.2023	A	2	0
02.01.2023	A	1	6

Now I would like to add a calculated column or an measure that shows me the Sum for each article regardles of the Department.

Date	Article	Department	Value	Value Final
01.01.2023	A	1	5	5
01.01.2023	A	2	0	5
02.01.2023	A	1	6	6

How would you do that in DAX?

[tamerj1 · Accepted solution]

Hi @joshua1990 
New column

Value Fina =
CALCULATE (
    SUM ( 'Table'[Value] ),
    ALLEXCEPT ( 'Table', 'Table'[Date], 'Table'[Article] )
)

Could work also as a measure