Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago
Solved

Sum Total

Hi, In my report, I have a Cluster Column Chart to display the last 12 months of Sales Volumn. So I can see the Sales Volumn of each month. How can I create the measure to sum all the Sales Volumn...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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's avatar
v-yadongf-msft
Community Support
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ?