Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
kampyy
Frequent Visitor

A measure to group by and concatenate

 

IDSub IDSub Level 
11level 3
12level 2
23level 3
34level 3
35level 1
46level 3
57level 2
68level 2



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

For EX.

IDSub IDSub Level New Column
11level 3level 3, Level 2 
12level 2level 3, Level 2 
23level 3level 3
34level 3level 3, Level 1
35level 1level 3, Level 1
46level 3level 3
57level 2level 2
68level 2level 2



Thanks in Advance

3 REPLIES 3
lbendlin
Super User
Super User

Your column names are rather confusing.  How are the tables connected?

I have updated the question.

Not sure what you are trying to achieve.  Are you looking for a parent child hierarchy?

 

Here is the PATH output based on your sample data

 

lbendlin_0-1664210611108.png

 

Why is the Sub ID different from the Sub Level ?

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.