Forum Discussion

RohithGn's avatar
RohithGn
Helper I
7 years ago
Solved

Aggregated Sum

Hi,   I have a table siilar to below -    Source Year county school Reponse Total surveys Hight School 2018 As asdf High Positive 20 Hight School 2018 As asdf Positive 20 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    So, you will probably need a measure like:

     

    Measure = 
SUMX(SUMMARIZE('Table',[Source],[Year],[county],[school],"__total",AVERAGE([Total surveys])),[__total])
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    RohithGn,

     

    The measure above seems to work. Here is a similar post for your reference.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

So, you will probably need a measure like:

 

Measure = 
SUMX(SUMMARIZE('Table',[Source],[Year],[county],[school],"__total",AVERAGE([Total surveys])),[__total])
RohithGn's avatar
RohithGn
Helper I
7 years ago

Thanks for the reply Greg.

Here is my expected output:

By default the sum should be 20+43+20+43=126

If i select Highschool in my Source slicer, the result should be 20+43 =63

If i select Highschool and the County as AS, the result should be 20

If i select County as AS, the result should be 20(High School)+20(Elementary) = 40

and so on...

 

 

 

 

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    RohithGn,

     

    The measure above seems to work. Here is a similar post for your reference.