Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line graph - adding a total average line

Hi,   I have a line graph showing sales by region (the regions are the legend). Please can you tell me how to add a "Total Sales" line (i.e. all the regions added together), while still showing the...
  • parry2k's avatar
    8 years ago

    create new measure for total sales something like this:

     

    Total Sales = Calculate(Sum(Table1[Sales]), All(Table1))