Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
| 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
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
Why is the Sub ID different from the Sub Level ?
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 41 | |
| 39 | |
| 22 | |
| 21 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 63 | |
| 38 | |
| 31 |