cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

 Name Skill John Doe Java John Doe .NET Michael Jordan Python Michael Jordan Scala

I would like to have the following outcome

 Name Skill John Doe Java/.NET Michael Jordan Python/Scala

Best,

1 ACCEPTED SOLUTION
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:

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.

3 REPLIES 3
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:

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.

Super User

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

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

Helper V

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?.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors