In a sales analyses project I have sales, customers, products and sales dates. Of course I have more then one sale for each customer.
In a measure, if I count the sales ou count the customers the returned value is always the number of sales, I think cube returns alway the number of facts.
I can see how many customes I have ( in Dimensions Editos, Items count ).
But if I filter some sales dates ( for instance ) I don't know how many clients I had in that date.
Well, in fact I've been problems of how to count dimensions.
I've read something like distinct clause ( like in databases ) but couln't find it in PVCube.
Best regards.