Concatenate unique values from multiple columns

[awadh]

Dears, 

I have below table

Custid	Bulding	Land	shares	cash
1	2	0	2	1
1	1	0	1	0
2	1	0	0	0
3	0	0	0	0
2	0	1	0	0
4	2	0	0	0

 i need to create new column coll type where the expected result have to be.

Custid	Colltype
1	Bulding, Shares, Cash
2	Bulding , Land
3
4	Bulding

[AllisonKennedy]

@awadh 

In Power Query, unpivot the data first: 

You can rename your columns here, but I'll keep as 'attribute' and 'value' to make this post more generic.

Then close and apply. Create a new MEASURE: 

Coll Type = CONCATENATEX(VALUES(awadh[Attribute]), awadh[Attribute], ", " )

Then add that to a table visual with your Custid: