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]...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Samarth-Borade 

what columns do you have in your grp table?

 

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!