Forum Discussion

Johan-MTM's avatar
Johan-MTM
Icon for Helper III rankHelper III
2 years ago
Solved

Add a column for row totals

Hi, How do I add a column that show a total for each row?  
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Total = SUMX(q2, q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK]) 

     

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

Johan-MTM , If the simple objective is to have a column that is the sum data in each row. For ex, the new column value for "Angereds bibliotek" is 34, then

Total = q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK]

should work.

 

If a measure is required,

Total = SUMX(q2, q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK]) 
should do the trick.