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 ...
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
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?
