Forum Discussion
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 | 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..
1 Reply
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.
