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 referan...
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
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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