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 Athletes in 2004 = CALCULATE(D...
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.
Thank You Ashish. I will try this and see how it goes.
Regards