How do I summarize a measure into a column?

[Samarth-Borade]

new_sales =

 CALCULATE([pp],ALLEXCEPT(grp,grp[_Customer Code]))

------------------

pp =

VAR TblSummary = ADDCOLUMNS(

                    SUMMARIZE(grp,grp[_Customer Code],grp[_EDC Tradelane],grp[_STC Tradelane]),

                    "SummaryCol",CALCULATE(SUM(grp[Rev])))

RETURN

    SUMX(TblSummary,[SummaryCol])

 -----------------------

IMP: pp is measure and i want new_sales as a NEW COLUMN which is same as pp.

Here pp and new_sales should be same.

using allexcept to summarize is giving wrong values.

[v-rzhou-msft]

Hi @Samarth-Borade ,

Do you want to calcualte the sum baed on group of three columns: grp[_Customer Code]/grp[_EDC Tradelane]/grp[_STC Tradelane]? Here I suggest you to try code as below to achieve your goal.

new_sales = 
CALCULATE(SUM(grp[Rev]),ALLEXCEPT(grp,grp[_Customer Code],grp[_EDC Tradelane],grp[_STC Tradelane]))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi @Samarth-Borade 

what columns do you have in your grp table?

[Samarth-Borade]

Table name : grp

Column: cust_name, cust_code, edc_lane, stc_lane,revenue

Slicers: cust_code,edc_lane,stc_lane

when i select cust_code in slicer : it is not summarzing up instead it is giving values for each.

code: 

new_sales = CALCULATE(SUM(grp[Rev]),ALLEXCEPT(grp,grp[_Customer Code],grp[_custname],grp[_EDC Tradelane],grp[_STC Tradelane])) 

Not working!