Dax Expression to concatenate and group by

[kampyy]

ID	Sub ID	Sub Level
1	1	level 3
1	2	level 2
2	3	level 3
3	4	level 3
3	5	level 1
4	6	level 3
5	7	level 2
6	8	level 2

Looking for DAX Expression to - create a comma separate column of "Sub Level" group by "ID"

For EX.

ID	Sub ID	Sub Level	New Column
1	1	level 3	level 3, Level 2
1	2	level 2	level 3, Level 2
2	3	level 3	level 3
3	4	level 3	level 3, Level 1
3	5	level 1	level 3, Level 1
4	6	level 3	level 3
5	7	level 2	level 2
6	8	level 2	level 2

Thanks in Advance

[amitchandak · Accepted solution]

@kampyy , A new column

concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[v-cgao-msft · Accepted solution]

Hi @kampyy ,

Made some edits, added separator parameter (",").

Column = CONCATENATEX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Sub Level],",")

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak · Accepted solution]

@kampyy , A new column

concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[UserSam123]

Hello,

Is it possible to make your formula dynamic in a measure?