#VALUE! error when totaling distinct counts in Front Page

[moemike]

I have created several cubes which use Distinct count as a derived
measure. When I publish the cubes via Front Page/Excel I receive a #VALUE!
error whenever the user selects multiple members in a page item list.

If the user selects only one or all, it works fine. The error also
shows up on the grand totals of the distinct count fields.

Thanks in advance for any help on this one.

-Mike