Forum Discussion

Samarth-Borade's avatar
Samarth-Borade
Frequent Visitor
3 years ago

How do I summarize a measure into a column?

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

    • Samarth-Borade's avatar
      Samarth-Borade
      Frequent Visitor
      3 years ago

      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!