Thanks Tim,

Originally I didn't want to take this approach but after struggling
trying to get the MDX to work the way I wanted it to I decided to
pre-calc as much of the data as I can in SQL Server and then populate
the cube and use the CountDistinct aggregation for the count of the
days. At this stage I get the results I am expecting.

Barry