DCountDistinct() determines how many distinct values of a field exist (first parameter), for those participants fulfilling a filter (second parameter):
DCountDistinct("[Club]"; "[Finished]") - returns the number of different clubs with finishers
Why the double quotes around the field names? Because the parameter is the name of the field that the function shall analyze!
Note that the aggregation functions are not very fast and should be used rarely.