Sum on key values

[Petenausen]

Hi,

I have to make a service level indicator on power bi.

I have a list of orders make by different customers. and I need to sum them to calculate fill rate.

How could i sum them only if the value of a column is the same?

For example

x 5

y 6

x 10

z 12 

y 3

I wanna have

x 15

y 9

z 12 

is it possible? thanks

[Phil_Seamark · Accepted solution]

HI @Petenausen

I use the following table 

Order	Value
x	5
y	6
x	10
z	12
y	3

And just dragged both columns to the canvas using a TABLE visual which automatically grouped the [Order] column and SUMed the [Value] column

[v-ljerr-msft · Accepted solution]

Hi @Petenausen,

In addition, you can also use the formula below to create a new summarize table in this scenario. 

Summarize Table = SUMMARIZECOLUMNS(Table1[Order],"Total Value",SUM(Table1[Value]))

Regards

[Phil_Seamark · Accepted solution]

HI @Petenausen

I use the following table 

Order	Value
x	5
y	6
x	10
z	12
y	3

And just dragged both columns to the canvas using a TABLE visual which automatically grouped the [Order] column and SUMed the [Value] column