Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago

Calculated Table

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 ...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

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.