Forum Discussion

bvsaicharitha's avatar
bvsaicharitha
Icon for Helper I rankHelper I
7 years ago

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 ...
Need Help
Tips and Tricks
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

try this

Total = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))
  • bvsaicharitha's avatar
    bvsaicharitha
    Icon for Helper I rankHelper I
    7 years ago

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

    • Stachu's avatar
      Stachu
      Icon for Community Champion rankCommunity Champion
      7 years ago

      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's avatar
        bvsaicharitha
        Icon for Helper I rankHelper I
        7 years ago

        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?