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]...
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.