Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Calculated Column with SUM in same Table and two Filters

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?

Need Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi joshua1990 
    New column

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

    Could work also as a measure

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi joshua1990 
    New column

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

    Could work also as a measure