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.
I'm looking forward to read your answers 🙂
Solved! Go to Solution.
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.
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.
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])
@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
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Mark your calendars and join us for our next Power BI Dev Camp!.
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.