Forum Discussion
duplicates?
make another visual like a bar chart that displays each name with the number of participation.
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.
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.