Calculated Table

[BIswajit_Das]

Hello

I Have a Calculated Table like

slno	mob	res1	gender
1	34	a	m
1	32	b	f
1	34	c	f
3	123	a	m
2	32	c	m
3	123	a	m
2	21	s	f
3	111	c	m
2	26	a	f

As per my requirement i want the table

summerized by mob column
I want all columns based on Summerised MOB column
Any Ideas
Thanks & Regrads..

[Sahir_Maharaj]

Hello @BIswajit_Das,

Can you please try this DAX:

SummarizedTable = 
SUMMARIZE(
    TableName,
    TableName[mob],
    "Distinct_slno", CONCATENATEX(DISTINCT(TableName[slno]), TableName[slno], ", "),
    "Distinct_res1", CONCATENATEX(DISTINCT(TableName[res1]), TableName[res1], ", "),
    "Distinct_gender", CONCATENATEX(DISTINCT(TableName[gender]), TableName[gender], ", ")
)

Should you require any questions or further assistance, please do not hesitate to reach out to me.