Forum Discussion
Johan-MTM
Helper III
Helper IIIAdd a column for row totals
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])
Johan-MTMHelper III
Helper IIIHow would the DAX look like if I want to create a new measure?
ChiragGarg2512
Solution Sage
Solution SageTotal = 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
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
change the table name to what you have.
- Johan-MTM
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?