I created a basic Distinct Count Measure for my customers - i.e. a customer distinct count using the default measures created in Analysis Services 2008 (not a calculation).
It works perfectly however, when used in conjunction with the below;
CREATE MEMBER CURRENTCUBE.[Time].[Time By Month].[Year-To-Date (Month)]
AS SUM(YTD(strToMember("[Time].[Time By Month].[month].&[" + str(year(Now())) + "-" + format((month(Now())), "00") + "-01T00:00:00" + "]").LAG(1)),[Measures].CurrentMember),
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Time';
View Complete Post