Forum Discussion
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 region splits?
Thanks,
CM
create new measure for total sales something like this:
Total Sales = Calculate(Sum(Table1[Sales]), All(Table1))
2 Replies
create new measure for total sales something like this:
Total Sales = Calculate(Sum(Table1[Sales]), All(Table1))
