cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ldpozo68
Frequent Visitor

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

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:
 
sum tABLE.png

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

 

Luis

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
Super User I

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

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:

image.png

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:

image.png

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! 🙂


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

Highlighted
ldpozo68
Frequent Visitor

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

 Hi Djerro,

 

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

View solution in original post

6 REPLIES 6
Super User I
Super User I

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

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! 🙂


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

Super User I
Super User I

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

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


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

ldpozo68
Frequent Visitor

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

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

Super User I
Super User I

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

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:

image.png

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:

image.png

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! 🙂


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

Highlighted
ldpozo68
Frequent Visitor

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

 Hi Djerro,

 

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

View solution in original post

Super User I
Super User I

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

image.png

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! 🙂


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors