I have a distinct count measure that I created when building the cube with the NUNIQUE DISTINCT . However, once the cube is surfaced , I would like to have this distinct measure where :
it only includes two members from a dimension ( SET A)
and SET A further restricts on two members from a nother dimension. I am having a hard time creating a calculated member with the distinct measure.
Any MDX clues?