sum column error

[vjnvinod]

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

[Anonymous]

@vjnvinod

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

TERFYTDUSD = SUM(Outbound[TER_FYTD_USD])

 Hope this helps,

Parker

[vjnvinod]

@Anonymous

thanks but

still not able to figure out, see the below error

[Anonymous]

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

[Anonymous]

@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

[vjnvinod]

@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?

[Anonymous]

@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

[vjnvinod]

@Anonymous

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

[Anonymous]

@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])
   )
)

[vjnvinod]

@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

[v-jiascu-msft]

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

[Ashish_Mathur]

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.