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