Hi,How do I add a column that show a total for each row?

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

Add a column for row totals | Microsoft Fabric Community

eliasayyy
Memorable Member
2 years ago
hello Johan-MTM either try using a matrix table or create a new measure that sums up all your measures and name it total
Johan-MTM
Helper III
2 years ago
How would the DAX look like if I want to create a new measure?
- ChiragGarg2512
  Solution Sage
  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])
  - Johan-MTM
    Helper III
    2 years ago
    Sorry ChiragGarg2512 , I didn't see your reply before I posted my question!
    
    I tried a new measure with your sugestion but got an error:
ChiragGarg2512
Solution 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.