Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Calculated columns -total subcat

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

Appreciate your reply. Thanks

/Henrik

Hi Anonymous ,

Try these:

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

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

Super User

Hi Anonymous ,

Try these:

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

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