Aggregate Rows

[sekinod]

Let's assume I have a table as below

And I want aggregate row as below

How can  I do that, thanks

[amitchandak · Accepted solution]

@sekinod , A measure

Total Sales  = sum(Table[sales])  In visual with customer

or when drag sales in field you can choose aggregation as sum

Or new table in dax

table = summarize(Table, Table[customer]) , "Sales",sum(Table[sales]) )