Hi Folks,

I want calculate the average daily usage over the selected time period, but
have not been able to figure it out. For the selected period, I want to
count all days in that period, and divide a measure by that count. If a
quarter is selected, I want the number of days in that quarter. If a month,
the number of days in that month. Any suggestions on how to do this?

Thanks,

Jim

Found the answer I needed.

COUNT(Descendants([Time].[Time].CurrentMember, Day))

returns the number of days over the selected periods



"Jim Davis" <jim.davis (AT) flexcar (DOT) com> wrote