Forum Discussion

RohithGn's avatar
RohithGn
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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
Icon for Helper I rankHelper 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
    Icon for Community Support rankCommunity Support
    7 years ago

    RohithGn,

     

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