Hi,

I have a cube with 'customer', 'product', 'geography' and 'Measure'
Dimensions.

I want to write a formula (calculated measure) that dynamically generates
the count of customers as per the filters applied on other dimensions like
‘product’ & ‘geography’.

For example:

I want to get a count of customers that has geography = 'EAST'
& product = 'HMO'.

Please note that there is no Measure involved in this scenario.

I tried creating a calculated member under 'Measure' with
[Product].members.count.

It always gives the same total number of customers no matter what filters I
apply on other dimensions.

Any help is greatly appreciated.

Thanks in advance

Prasad.