Forum Discussion

eijer's avatar
eijer
Helper I
7 years ago
Solved

Measure summarizing by group

I want to create a measure that adds up the sales amount of each salesperson. Please refer to the example below. The name of the table is Sales.

 

PriceSales-man
100John
100Michael
200Ron
300Juile
100John
200John
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi eijer ,

     

    Drag [Price] and [Sales-man] into a Table visual, it will sum up the sales amount per salesperson automatically.

     

    Additionally, you could refer to below measure.

    Sum price = SUM(Sales[Price])

     

    Best regards,

    Yuliana Gu

3 Replies

  • um_mir's avatar
    um_mir
    Frequent Visitor
    7 years ago

    Hi eijer 

     

    Try below measure

     

    TotalPrice = SUMX(Sales,Sales[Price])
     
    Hopefully this works for you.
    • eijer's avatar
      eijer
      Helper I
      7 years ago

      um_mir 

       

      Thanx for your help, howerver; it wasn't I wanted.

       

      A formula is required to obtain the sum of the sales figures for each salesperson.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi eijer ,

     

    Drag [Price] and [Sales-man] into a Table visual, it will sum up the sales amount per salesperson automatically.

     

    Additionally, you could refer to below measure.

    Sum price = SUM(Sales[Price])

     

    Best regards,

    Yuliana Gu