I am trying to add column values in each row to produce a totals column but doesn't work

[Anonymous]

I have tried to use SUM to add up the column values in each row and the final value is not right

My formula is as follows:

Totals = sum('Outstanding Work'[Key])+sum('Outstanding Work'[Verify])+sum('Outstanding Work'[Submit])+sum('Outstanding Work'[1ST TRACK])+sum('Outstanding Work'[2ND TRACK])+sum('Outstanding Work'[Outstanding HDMs])

this is the table with the Totals column:

This is driving me crazy. Any help would be appreciated.

Luis

[JarroVGIT · Accepted solution]

Thanks for sharing the PBIX. First off; try updating your PBI desktop (it doesn't relate to this issue, but always good to be up to date as I got a compatibilty message 🙂 )

Then on to your issue. The Key column has it's summarization set to COUNT, not SUM:

If this is correct, you need to change your measure accordingly:

Totals = COUNT('Outstanding Work'[Key])+SUM('Outstanding Work'[Verify])+SUM('Outstanding Work'[Submit])+SUM('Outstanding Work'[1ST TRACK])+SUM('Outstanding Work'[2ND TRACK])+SUM('Outstanding Work'[Outstanding HDMs])

Result:

Let me know if this answers your question 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[JarroVGIT]

Are the other columns just column references or are these measures? If they are measures, could you share them? If they are column references, would it be possible to share your PBIX (can also via PM if you don't want to share publicly)? There is definitely something funny going on but we have to little to go on here 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

no the data is not a measure but it is in a matrix 

I dont want to share publicly and I didnt see an attachment option in the pm section

Regards,

Luis

[JarroVGIT · Accepted solution]

Thanks for sharing the PBIX. First off; try updating your PBI desktop (it doesn't relate to this issue, but always good to be up to date as I got a compatibilty message 🙂 )

Then on to your issue. The Key column has it's summarization set to COUNT, not SUM:

If this is correct, you need to change your measure accordingly:

Totals = COUNT('Outstanding Work'[Key])+SUM('Outstanding Work'[Verify])+SUM('Outstanding Work'[Submit])+SUM('Outstanding Work'[1ST TRACK])+SUM('Outstanding Work'[2ND TRACK])+SUM('Outstanding Work'[Outstanding HDMs])

Result:

Let me know if this answers your question 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous · Accepted solution]

 Hi Djerro,

I dont know why you see count. This is my desktop capture...

[JarroVGIT]

The number in your matrix represents a COUNT of the Key column, not a SUM. This is confirmed when you clik on the little arrow in the Columns field of the visual like the screenshot above. Changing your measure to use COUNT for the calculation as well for the Key column fixed the issue for you (now you get 172 in the first row). I don't know if you need COUNT or SUM, that is up to you of course.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[JarroVGIT]

If they are column references, do the value represent distinct counts? Or are they number columns and are they summarized as sums?