Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
How to convert measure to calculated column . I need Calculated column sum.
Appreciate your reply. Thanks
/Henrik
Solved! Go to 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] ) )
)
Proud to be a Super User!
Hi,
thanks I got what I need. Thank you.
Regards Henrik
Hi,
sorry this gives the same results as Subtot.
I want R53_total as calculated columns e.g. total of subcategory.
Thanks.
Rgds
Henrik
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] ) )
)
Proud to be a Super User!
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |