Add a column for row totals

[Johan-MTM]

Hi,
How do I add a column that show a total for each row?

[ChiragGarg2512]

@Johan-MTM , If the simple objective is to have a column that is the sum data in each row. For ex, the new column value for "Angereds bibliotek" is 34, then

Total = q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK]

should work.

If a measure is required,

Total = SUMX(q2, q2[Antal lan lantagare under 18]+q2[Antal lan vuxna lantagare]+q2[Antal lán bibliotek]+q2[Antal lán TBK]) 

should do the trick.

[Johan-MTM]

How would the DAX look like if I want to create a new measure?

[ChiragGarg2512 · Accepted solution]

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-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?

[ChiragGarg2512]

@Johan-MTM , q2 is name of the table in my pc, replace it with the name of table in your system.

[Johan-MTM]

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!

[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:

https://learn.microsoft.com/en-us/dax/sumx-function-dax

[eliasayyy]

hello @Johan-MTM either try using a matrix table or create a new measure that sums up all your measures and name it total