trouble with distinccount..

Hello,

I have a cube with a lot of dimensions. Two of them are ItemNo and LocationCode. I need to have two measures "Locations Shipped To" and "Item Count". For those, I need to have a count of different locations/items matching current dimension filters. So I tried adding a calculated member:

distinctcount({[Item].Members})

but it only shows 0 or 1 :(

Am I missing something here?

thanks.

Hi:

Take a look at my articles at:

http://www.databasejournal.com/featu...le.php/3454931

and at:

http://databasejournal.com/features/...le.php/3482536

If you still have issues, let us know, but the stuff you're trying to do should be well within the scope of the "basics" discussion.

Good Luck!

Bill

I made a dumb mistake back there - fixed it, and it works now.. Somewhat. I have a problem though.

Say I have Item and Location dimension.

If I select single Location, then ItemCount shows correct count. But if i select two or more Locations, then ItemCount shows count as if all the Locations where selected.. :(

Any ideas why would it be so..?