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