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

 

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

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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'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

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    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.

  • 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