Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated columns -total subcat

Hi   How to convert measure to calculated column . I need Calculated column sum.   Appreciate your reply. Thanks   /Henrik  
Show and Tell
  • danextian's avatar
    danextian
    3 years ago

    Hi Anonymous ,

     

    Try these:

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

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, 

 

thanks I got what I need. Thank you.

 

Regards Henrik