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 IIIThank you! NOw I understand a bit more, but I do need to have seomthing there in order fpr it to work? If I remove the table name I get "Too few arguments..."
Total = SUMX([Antal lån låntagare under 18]+[Antal lån vuxna låntagare]+[Antal lån bibliotek]+[Antal lån TBK])
ChiragGarg2512
Solution Sage
Solution SageJohan-MTM , I meant the name attached to measure, like 'table'[measure] and [measure] work the same way. The reason for "Too few argument" is that the function sumx require twoarguments, name of the table and the expression. The name of the table is not optional.
For more information on sumx refer to this link by microsoft: