OK, I am sorry. What I just posted is not the case. My test was not complete. It in fact did not work. I cannot seem to make a distinct count measure work when selecting multiple members of a dimension. Sorry for the false post.
I have been having the same problem and have an idea. I have a distinct count measure in my cube and when I go to validate the data in Excel I am also getting the #Value! error when selecting individual members where I do not get the error if I choose All.
Explanation of data setup:
I have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.