duplicates?

[RoxanaZaharia]

Hello! I am working with this data set for my first project: https://www.kaggle.com/datasets/krishd123/olympics-legacy-1896-2020 , and i am trying to show top participants by the number of times they participated in the Olympic games. I was randomly filtering the name column just to show me one person, and i noticed that many rows are the same (photo). My question is, will the solution be affected by this and is creating a measure with the COUNTROWS function a good approach to solve this?  

[MNedix]

The result makes sense because you have multiple values for Event (for one unique person). To get what you want, you have to create an additional measure using CONCATENATEX which will bring all the Event values into one row.

[Idrissshatila]

Hello @RoxanaZaharia,

no because each row seems to be for a specific year, so this athlete participated in this event for this year then for the year after, so if each row is a participation then you can do countrows and view it alogside the name of the athlete.

[RoxanaZaharia]

Hello @Idrissshatila ,

Is there a way to show details about their participation (Sport, Event, Season) and at the same time display the top participants by the number of times they participated in the Olympic Games? Because when I add details about their participation, the result will be like in the photo below, where their names appear scattered all over, so I lose the number of times (total) they participated in the Olympic Games.

[Idrissshatila · Accepted solution]

@RoxanaZaharia ,

make another visual like a bar chart that displays each name with the number of participation.

[MNedix]

Hi,

You could try a measure DISTINCTCOUNT on the 1st column. Once you add the Name as a filter it will then show you all names with their participations in Olympics. If you get too many results, you can then use the TOPN function to limit the view to Top 25 for example.

PS: if this answers your question please mark it as a solution so others can see it.

[RoxanaZaharia]

I've tried this method, and I have a question: Is there a way to show details about their participation (Sport, Event, Season) and at the same time display the top participants by the number of times they participated in the Olympic Games? Because when I add details about their participation, the result will be like in the photo below, where their names appear scattered all over, so I lose the number of times (total) they participated in the Olympic Games.