Dax - show the total for each row by two columns

[twwister8889]

Hi guys,

I need to show the total value for each row in the table by Column.

How can I do this using DAX?

A	Item	Value	Expected result
Cat1	1	10	25
Cat1	2	15	25
Cat2	1	20	20
Cat3	5	30	30

[Martin_D]

Is this what you are looking for?

Expected Result = 
CALCULATE (
    SUM ( 'Table'[Value] ),
    ALLEXCEPT ( 'Table', 'Table'[A] )
)

Total by category