Forum Discussion
Helper IIIAdd a column for row totals
Total = SUMX(q2, q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK])
Solution SageJohan-MTM , q2 is name of the table in my pc, replace it with the name of table in your system.
Helper IIIAlright, here we go 🙂 All the tables but the first one (Bibliotek) are measures so this worked fine!
Big thanks for your patiens!
- ChiragGarg2512
Johan-MTM , This is because the measure once created are part of the model rather than that particular table. These measures can be acessed from anywhere without the name of table being attached to it, the names can be attached but it will work either way.
Thank You, if this solves the issue mark it as solution so that the community can fnd the solution easily.
- Johan-MTM
Thank 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
Johan-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: