Line graph with summation values

[bvsaicharitha]

For the data given below and the graph attached, I need a additional line graph of the summation of mobile sales in the same graph showing the brands. Please help me. I want to see how my entire mobile sales are growing and also individual brands over time on the same line graph 

Type	Brand Name	Sales	Date
Mobile	A	1000	Jan
Mobile	B	1500	Jan
Mobile	C	2300	Jan
Mobile	D	5000	Jan
Mobile	A	1450	Feb
Mobile	B	1678	Feb
Mobile	C	1674	Feb
Mobile	D	1683	Feb

[Stachu]

try this

Total = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))

[bvsaicharitha]

If I create a total measure, how can i include that in the existing graph? 

[Stachu]

I thought that you can use multiple measures with a legend but that's not the case
you would need to remove the Brand Name from the legend, and create set of measures per Brand, e.g.

A = CALCULATE(SUM('Table'[Sales]), 'Table'[Brand Name]="A")  

then you can have multiple measures in a visual, but I imagine that's lot of effort with multiple brands

[bvsaicharitha]

I think If I add an extra custom row with the summation of the total, then,I can use it in the graph.  Can you help me how can i create such custom row?

[v-piga-msft]

Hi @bvsaicharitha,

I'm afraid that we may not add custom rows in power bi.

Actually, I'm a little confused about your requirement.

If it is convenient, could you share your desired output so that we could help further on it?

Best  Regards,

Cherry

[bvsaicharitha]

Hi,

This is the similar output that I am interested .

Example ,the top green one is the summation of all the brand sales and the rest colors are the individual brands . Ideally, when I create the line graph, I will only get the individual ones by setting legend. I am interested to see the total as well in the same graph. Now the green  graph is total of all sales over period