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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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