Forum Discussion

adavid999's avatar
adavid999
Helper V
6 years ago

Simple calculation

Hi, Please could you remind how best to acheive this...I have table data and would like a new column or measure that shows sum of score for each question based on year, so total for question 1 would...
Need Help
FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi adavid999 ,

take a look at the figure:

 

Regards FrankAT

 

  • adavid999's avatar
    adavid999
    Helper V
    6 years ago

    Thanks FrankAT I guess i should have been clearer - i need to be able to use the sum in another calculation.

    Cheers,

    A

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      adavid999 - If you need the sum in a different calculation it would help to know the calculation. But, in general you could do something like:

       

      Measure = 

        VAR __Table = SUMMARIZE('Table',[Question],"__Score",SUM([Score]))

      RETURN

        <some calculation across __Table>

      • adavid999's avatar
        adavid999
        Helper V
        6 years ago

        thanks Greg_Deckler I will try this and if I don't get anywhere (likely) I will try and more clearly state what I am trying to acheive...

        A