topic Re: How do I summarize a measure into a column? in DAX Commands and Tips

How do I summarize a measure into a column?

Samarth-Borade — Wed, 01 Feb 2023 19:55:16 GMT

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.

Re: How do I summarize a measure into a column?

FreemanZ — Wed, 01 Feb 2023 23:55:16 GMT

hi Samarth-Borade

what columns do you have in your grp table?

Re: How do I summarize a measure into a column?

Anonymous — Thu, 02 Feb 2023 07:29:27 GMT

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.

Re: How do I summarize a measure into a column?

Samarth-Borade — Thu, 02 Feb 2023 08:25:37 GMT

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!