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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
fernandoC
Helper V
Helper V

How to group values from a column based on the value of another one

Hi!

 

Wanted to reach out as I´ve been trying to find a way to achieve the following:

 

I have a table that has the following structure

 

NameSkill
John DoeJava
John Doe.NET

Michael Jordan

Python
Michael JordanScala

 

I would like to have the following outcome

 

NameSkill
John DoeJava/.NET
Michael JordanPython/Scala

 

Thank you for your assistance.

 

Best, 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @fernandoC ;

You could create a measure or column :

1.create a measure.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

2.create a column.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

The final output is shown below:

vyalanwumsft_0-1637561763491.png

vyalanwumsft_1-1637561771386.png

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

Hi, @fernandoC ;

You could create a measure or column :

1.create a measure.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

2.create a column.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

The final output is shown below:

vyalanwumsft_0-1637561763491.png

vyalanwumsft_1-1637561771386.png

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@fernandoC , Create a measure and use it with name, in visual

 

measure = concatenatex(Table, Table[Skill], "/")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak 

 

I tried using a measure but I'm not getting the expected results. When used in a table visual the results are not being grouped based on the Name. Any suggestions?. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.