Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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  Athletes in 2004 = CALCULATE(D...
Need Help
AbhinavJoshi's avatar
AbhinavJoshi
Responsive Resident
2 years ago

Hi Anonymous .

Can you please provide a sample of your data model?
General advice would be looking for filters coming to your visual.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

https://app.powerbi.com/groups/me/reports/5d6e9c2b-7525-4805-906d-4c1f1bffc8bd/7876d8eb8502623ef626?ctid=34531318-7011-4fd4-87f0-a43816c49bd0&pbi_source=shareVisual&visual=2eb52e4b5282b72ae687&height=611.42&width=771.61&bookmarkGuid=ec710de0-c0c5-4dd3-9f4f-492dcb551587

 

Regards