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.