Forum Discussion
Line graph with summation values
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 |
6 Replies
try this
Total = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))
If I create a total measure, how can i include that in the existing graph?
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
