Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Aggregation on Record level

Hey Experts,

 

I am having an issues while creating a formula for Aggregation(Sum or Subtraction) on Record level on a Single dimension column.

my data is like in the below format for your referance.

 

CountrySales
India$150
Australia$200
America$500
China$750
Japan$620

 

Now i need to get aggregation on Sales of India+America and China-Japan.

Please Help me on this.

 

TIA,

Habib Shaik.

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 years ago

    Anonymous

     

    you can try formula like below

     

    test = CALCULATE(SUM('table'[Sales]),FILTER('table','table'[Country] in {"India","America","China","Japan"}))
     
    Thanks and BR
    Ryan

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    7 years ago

    Anonymous

     

    you can try formula like below

     

    test = CALCULATE(SUM('table'[Sales]),FILTER('table','table'[Country] in {"India","America","China","Japan"}))
     
    Thanks and BR
    Ryan
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Habib,

     

    I would suggest you create some groups of the countries. Then it's easy to get "sum of" and to show them in the visual. Please refer to the snapshot below.

    How-to-group-my-Year-Month-field-into-just-3-values

     

    Best Regards,
    Dale