Aggregation on Record level

[Anonymous]

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.

Country	Sales
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.

[v-jiascu-msft]

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.

Best Regards,
Dale

[ryan_mayu · Accepted solution]

@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