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
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper 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