topic Re: sum column error in Desktop

sum column error

vjnvinod — Fri, 11 May 2018 18:00:06 GMT

hi ,I need to sum all the values of one coloumn, but unfortunately it showing some syntax error?

can someone have a look and let me know, how to fix this?

Regards, vinod

Re: sum column error

Anonymous — Fri, 11 May 2018 18:05:19 GMT

vjnvinod

You have an extra ")" where it should be a "]". Try this:

TERFYTDUSD = SUM(Outbound[TER_FYTD_USD])

Hope this helps,

Parker

Re: sum column error

vjnvinod — Fri, 11 May 2018 18:10:15 GMT

Anonymous

thanks but

still not able to figure out, see the below error

Re: sum column error

Anonymous — Fri, 11 May 2018 18:12:44 GMT

vjnvinod

It looks like you're trying to do this sum in a Calculate Table expression. Try creating a measure or calculated column and then try this formula.

Parker

Re: sum column error

vjnvinod — Fri, 11 May 2018 18:15:42 GMT

Anonymous

thanks,

I actually wanted to create a new table, by summing up of one of my coloumn in a different table.

how do i do that?

Re: sum column error

Anonymous — Fri, 11 May 2018 18:25:38 GMT

vjnvinod

There may be a more elegant way of doing this but this works:

Table =
SELECTCOLUMNS(
   FILTER(
      Outbound,
      Outbound[TER_FYTD_USD]
   ),
   "New Column",
   SUM(Outbound[TER_FYTD_USD])
)

Hope this helps,

Parker

Re: sum column error

Anonymous — Fri, 11 May 2018 18:33:56 GMT

Maybe create a Measure with a formula like TERFYTDUSD = CALCULATE(SUM(Outbound[TER_FYTD_USD]))

Re: sum column error

vjnvinod — Fri, 11 May 2018 18:35:47 GMT

Anonymous

Hi, this still doesn't works, see the screenshot how the output is displayed.

Re: sum column error

Anonymous — Fri, 11 May 2018 18:40:18 GMT

vjnvinod

Well we're getting closer. Try limiting to just 1 row using this formula:

Table =
TOPN(
   1,
   SELECTCOLUMNS(
   FILTER(
      Outbound,
      Outbound[TER_FYTD_USD]
   ),
   "New Column",
   SUM(Outbound[TER_FYTD_USD])
   )
)

Re: sum column error

vjnvinod — Fri, 11 May 2018 19:22:17 GMT

Anonymous

this may not work in my other situations, I created a new coloumn using the below

SummarisedAccountsector = SELECTCOLUMNS(Inbound,"Sector",Inbound[AccountSector],"USD",Inbound[TER_FYTD_USD])

But whats happening is, i have only 3 account sector (Technology, Media & entertainment and Telecom)

my main issue is its not grouping the sector and their respetive aggregate sums

see the table table below

Sector	USD
Technology	400000
Technology	400000
Technology	400000
media & entertainment	400000
media & entertainment	400000
media & entertainment	400000
telecom	700000
telecom	700000
telecom	700000

Expected table

Sector	USD
Technology	400000
media & entertainment	5000000
telecom	700000

Re: sum column error

Ashish_Mathur — Fri, 11 May 2018 23:15:23 GMT

Hi,

How have you arrived at the numers in the Expected table - they are difinitely not additions. Anyways, just drag Sector to the row labels of the Table visual and then write a simple SUM measure

=SUM(Data[USD])

Hope this helps.

Re: sum column error

v-jiascu-msft — Tue, 15 May 2018 02:09:25 GMT

Hi vjnvinod,

1. If you want to put a single value in a table, you could try the formula below.

Table 3 = {sum(FactSales[SalesQuantity])}

2. You can try the following formula to get the expected table.

SummarisedAccountsector =
SUMMARIZE (
    Inbound,
    Inbound[AccountSector],
    "USD", SUM ( Inbound[TER_FYTD_USD] )
)

Best Regards,

Dale