Forum Discussion
Add 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])
change the table name to what you have.
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?
Johan-MTM , q2 is name of the table in my pc, replace it with the name of table in your system.
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!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.