Summarise on multiple columns

Question

Is there a way that I can merge the values based on multiple columns?

My table is below with the layout of the data.

What I want to happen is if the Client, Item number, the description and the price is the same then it would sum the quantity and merge them all into one row.

Date	Client	Item Number	Description	Price	Quantity	Invoice No.
14/01/2022	John Doe	04_102_0136_6_1_T	Group Activities	59.88	1	6370
14/01/2022	John Doe	04_102_0136_6_1_T	Group Activities	59.88	2.5	6370
14/01/2022	John Doe	04_102_0136_6_1_T	Group Activities	59.88	3.33	6370
14/01/2022	John Doe	04_104_0125_6_1_T	Grp Non Face to Face	59.67	1.5	6370
14/01/2022	John Doe	04_599_0136_6_1	Community Groups	2.17	1.67	6370
14/01/2022	John Doe	04_599_0136_6_1	Community Groups	2.17	2.5	6370
14/01/2022	John Doe	04_599_0136_6_1	Community Groups	2.17	4	6370
14/01/2022	John Doe	04_599_0136_6_1	Group Activities	2.17	1	6370
14/01/2022	John Doe	04_599_0136_6_1	Group Activities	2.17	2.5	6370
14/01/2022	John Doe	04_599_0136_6_1	Group Activities	2.17	3.33	6370

samarth_18 · Accepted Answer

Hi&nbsp;ITMSPMAN&nbsp;,
&nbsp;
If you add your&nbsp;Client,&nbsp;Item number, the&nbsp;description&nbsp;and the&nbsp;price columns on your visual and&nbsp; mark price column summerized as sum then it will give you expected output.

Or if you want to do it explicitly then you can use below measure:-
Measure = sumx(SUMMARIZE('Table','Table'[Item Number],'Table'[Client],'Table'[Description],"Sum",CALCULATE(SUM('Table'[Price]))),[Sum])
&nbsp;
Thanks,
Samarth

Forum Discussion

Summarise on multiple columns

2 Replies

Related content

Grouping and summarising

Multiple summarised columns in calculated table

Sequential Order column based on multiple criteria

Summarise

Multiple line and clustered columns chart