Forum Discussion
Distinct Count
I am working on a data set, in which i want to select the atheletes participated in an event from a particular year. The Dax that i am using for E.g for year 2004 is
6 Replies
Hi Anonymous .
Can you please provide a sample of your data model?
General advice would be looking for filters coming to your visual.Hello Abhinav,
Thank you for replying. I am not sure how to share the file, here is the link for the file.In this data i am trying to see how athletes participation has increased over time from 1976-2008 olympics. That means i need to get the unique count of Athletes for every year, and thats where i am getting the wrong value.
Regards
Hi,
There is no mistake in your measure. However, you should not hard code 2004 in the filter argument of the Calculate function. Create a year slicer from the Calendar Table and select 2004 there. Simplify your measure to
Athletes = DISTINCTCOUNT('Summer-Olympic-medals-1976-to-2'[Athlete ID])
Hope this helps.
Hi Anonymous ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
