Line graph - adding a total average line

[CloudMonkey]

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

[pxg08680]

@CloudMonkey

You can create a calculated column as mentioned by @parry2k

Coming to the visual, you can make use of POWERKPI chart instead of a simple Line Chart to show both line at one time.

[parry2k · Accepted solution]

create new measure for total sales something like this:

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