Calculated columns -total subcat

[Henrik_99]

Hi

How to convert measure to calculated column . I need Calculated column sum.

Appreciate your reply. Thanks

/Henrik

[Henrik_99]

Hi, 

thanks I got what I need. Thank you.

Regards Henrik

[Henrik_99]

Hi,

sorry this gives the same results as Subtot.

I want R53_total as calculated columns e.g. total of subcategory.

Thanks.

Rgds

Henrik

[danextian · Accepted solution]

Hi @Henrik_99 ,

Try these:

=
CALCULATE ( SUM ( 'Table'[Planned] ), ALLEXCEPT ( 'Table', 'Table'[R53] ) )

=
CALCULATE (
    SUM ( 'Table'[Planned] ),
    FILTER ( ALL ( 'Table' ), 'Table'[R53] = EARLIER ( 'Table'[R53] ) )
)