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,

 

sorry this gives the same results as Subtot.

 

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

 

Thanks.

 

Rgds

Henrik