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

Calculate the total sum of a column (sales)

Hi everyone,

 

I need to know how to calculate the total sum of a column (sales) , so I can calculate the percentage of share sales considering rows  such as year, month, brand and client.

Here is an example of what I want, but in Power BI.

biii.JPG

 I'm looking forward to read your answers 🙂

1 ACCEPTED SOLUTION
Continued Contributor
Continued Contributor

Hi Alessandra,

attached pbix with the measures.  maybe it helps.

customer matrix with %

 

View solution in original post

8 REPLIES 8
Super User III
Super User III

you can sales column again and chooise "show % of grand total" in arrow next to sales column.

 

If this doesn't work, I can write measure for you. try this above first.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hi parry2k,

 

I'd really aprecciate if you can write the measure for me. 

try this:

 

Sales = SUM(Table[Sales])

Total Sales = Calculate([Sales], All([Table])

% Sales = DIVIDE([Sales], [Total Sales], 0)

Add above 3 measures, drop sales and % sales in matrix. Make sure change the format of "% sales" to % under data modelling tab.

 

 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Continued Contributor
Continued Contributor

indeed, with this solution we come to a desired resultcustomer matrix.JPG

 

 

 

It didn't work.

Here is what I have in Power BI ( it's in spanish)

total vtas= total sales= CALCULATE([VtaVol],E1_T0_C0509_P0001_F1) --> The result it's the same what I got in sales, and It should appear for each row 26.86, which is the sum of the column sales, so in that way I can calculate the % of share sales

VtaVol = sales=  SUM(E1_T0_C0509_P0001_F1[VentaVol])

 

powerbiii.JPG

Continued Contributor
Continued Contributor

Hi Alessandra,

attached pbix with the measures.  maybe it helps.

customer matrix with %

 

View solution in original post

Thank You SO MUCH Pawel1! 😄

@Alessandra not sure why it will not work, make sure your dax expression for total sales is correct

 

it must have ALL function in there






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors