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...
Thanks FrankAT I guess i should have been clearer - i need to be able to use the sum in another calculation.
Cheers,
A
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>