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.

vanessafvg's avatar
vanessafvg
Community Champion
3 years ago

are you able to share some of your data in text form or show what you data looks like.  In order ot provide date intelligence you need to link your transactional date to a continious date table.