MDX Query - Count Of

[dky1e]

Hi,

Let's say i have a measure that is the Average of values in the cube and then another a distinct count of customers.

So, for example

PRODUCT   NUM_CUST    AVG_PRICE
A         20          $400
B         10          $500

Now, I want to add a calculated member that would do a distinct count (as customers can purchase more than once) and give me the number of customers that paid within 10% of the average price.

Is it possible? Please provide a quick sample mdx i could learn from.

Thanks.