Combine and SUM multiple columns

[Progressive]

Hi,

I created dashbord table and I would like to combine the column1 with commas and SUM the column2 based on column3. Is it possible?

I have a table like this,

Column1,Column2,Column3

A	5	XX
B	10	XX
C	12	XX
D	3	YY
F	8	YY
G	15	ZZ
Y	4	SS
H	1	BB

Final result should be like below

Column1,Column2,Column3

A,B,C	27 (5+10+12)	XX
D,F	11(3+8)	YY
G	15	ZZ
Y	4	SS
H	1	BB

Thanks in advance.

[v-yulgu-msft]

Hi @Progressive,

Alternatively, you could new a calculated table with this formula:

New Table =
SUMMARIZE (
    Table,
    Table[Column3],
    "Column1", CONCATENATEX ( Table, Table[Column1], "," ),
    "Column2", SUM ( Table[Column2] )
)

Best regards,

Yuliana Gu

[Progressive]

Hi @v-yulgu-msft,

I tried your formula and it works with one downside. Now, I have duplicates in Column1. Like A,B,C,A,A,A,A

Is there anyway to remove dubs in Column1. Something like DISTINCT SUMMARIZE 🙂

[Greg_Deckler · Accepted solution]

Create a meausre like this:

Measure = CONCATENATEX(VALUES('Table'[Column1]),[Column1],",") 

Create a table visualization with Column 3, Column 2 with default SUM and this measure.