Forum Discussion

Icon for Helper III rank

Helper 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?

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])

Icon for Helper III rank

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:

Icon for Solution Sage rank

Solution Sage

2 years ago

change the table name to what you have.

Johan-MTM
Helper III
2 years ago
Total = SUMX(q2, q2[Antal lån låntagare under 18]+q2[Antal lån vuxna låntagare]+q2[Antal lån bibliotek]+q2[Antal lån TBK])
I'm sorry but I don't get it 🙂 The error message points to "q2", should I replace this with something?
- ChiragGarg2512
  Solution Sage
  2 years ago
  Johan-MTM , q2 is name of the table in my pc, replace it with the name of table in your system.
  - Johan-MTM
    Helper III
    2 years ago
    Alright, here we go 🙂 All the tables but the first one (Bibliotek) are measures so this worked fine!
    Total = SUMX('public loan',[Antal lån låntagare under 18]+[Antal lån vuxna låntagare]+[Antal lån bibliotek]+[Antal lån TBK])
    
    One thing tho - Its the same result if I have Public loan or Public library or any other table name as format, why is that? Does it matter?
    
    Big thanks for your patiens!