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 IIIAlright, 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!
Big thanks for your patiens!
ChiragGarg2512
Solution Sage
Solution SageJohan-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.