cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Sum of a column

I have a simple table recording Project Managment Information

Each row contains information of a Project Deliverable or resource. 

I have a column which idetnifies which Directorate the deliverable owns the deliverable and one column which holds the total cost of the resoure.

I want to show in a pie or bar chart the total spend per directorate (on an ongoing basis) as this table will continue to be populated during this financial year. 

 

I'm struggling to find the correct formula for this and despite trying various methods I cannot get to see this in what I thought shoudl be straight forward?

 

Can anyone suggest a solution?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Sum of a column

@MMJen

 

Please check your data format and try the solution provided by smoupre, it should be correct.

 

Sum of a column_1.jpg

 

Best Regards,

Herbert

View solution in original post

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: Sum of a column

Given what you describe, you should be able to drag your cost column to the "Values" of the pie chart and your Directorate column to your "Category" for the pie chart and set your "Value" aggregation to "SUM". 


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

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Sum of a column

Hi,

 

Thank you for this.  This does give me a Pie chart per category which is a good start now.  However, it's giving me the Count of the cost not the SUM and i can't see an option under Values or the visualization to give me the SUM here?  Any thoughts?

 

It seems to work on other charts but not this one. 

 

Highlighted
Super User IX
Super User IX

Re: Sum of a column

Sounds like your Value came in as Text. You need to convert it to a numeric value (Decimal or Whole Number) either in the Query Editor or in the data model (middle icon on the left).


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

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: Sum of a column

@MMJen

 

Please check your data format and try the solution provided by smoupre, it should be correct.

 

Sum of a column_1.jpg

 

Best Regards,

Herbert

View solution in original post

Highlighted
Helper I
Helper I

Re: Sum of a column

Thanks all, that's it working, great. 

Another lesson learned..

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors