Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

sum column error

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  
Need Help
Show and Tell
vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

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

SectorUSD
Technology400000
Technology400000
Technology400000
media & entertainment400000
media & entertainment400000
media & entertainment400000
telecom700000
telecom700000
telecom700000

 

Expected table

 

SectorUSD
Technology400000
media & entertainment5000000
telecom700000

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

sum_column_error

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