Forum Discussion
Sum Total
Hi sarikei ,
Please create following measures:
Sales = SUM('Table'[Sales Volumn]) TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALL('Table')) % = DIVIDE([Sales],[TotalSales])The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
sorry, I should have included the dataset. For example:
| Month | Sales Volumn | Total Sales Volumn | % Sales Volumn |
| 2021-10 | 226 | 2248 | 10.05% |
| 2021-11 | 281 | 2248 | 12.50% |
| 2021-12 | 150 | 2248 | 6.67% |
| 2022-01 | 123 | 2248 | 5.47% |
| 2022-02 | 208 | 2248 | 9.25% |
| 2022-03 | 226 | 2248 | 10.05% |
| 2022-04 | 157 | 2248 | 6.98% |
| 2022-05 | 218 | 2248 | 9.70% |
| 2022-06 | 140 | 2248 | 6.23% |
| 2022-07 | 171 | 2248 | 7.61% |
| 2022-08 | 220 | 2248 | 9.79% |
| 2022-09 | 128 | 2248 | 5.69% |
1. Total Sales Volumn is what I want to sum. This is the total of Sales Volumn of all the all Month.
2. Then I will use this measure (Total Sales Volumn) to calculate the % Sales Volumn (fomular is Sales Volumn / Total Sales Volumn).
3. So I will include this 3 measure in the Column Chart.
Thank you in advance.
Hi sarikei ,
Please create following measures:
Sales = SUM('Table'[Sales Volumn])
TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALL('Table'))
% = DIVIDE([Sales],[TotalSales])
The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yadongf-msft i have one doubt if i am select any particular Date is ther any possible to change total sales values based sales ?