Hi,

i try to construct something like a distinct sum.
The Problem ist that my dimension and fact is n:m related.
(I know this is not the idea of this but i need it like
that...)

The Structure should be
All(6)
Group1(all=4)
------Fact1 (1)
------Fact2 (3)
Group2(all=1)
------Fact1 (1)
Group3(all=3)
------Fact1 (1)
------Fact3 (2)
Fact-Values in brackets

Adding the measure i get 8 not 6.

sum(Distinct((Descendants([Measures].[measurevalue]))))
gets also 8

Thanks for any idea
Tom