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.

how many members your item dimension have?

try: distinctcount(Item.ItemNo.Members)



<algkep (AT) gmail (DOT) com> wrote

It has around 500 members. I'm not sure what happened there, but it
seems to work correctly now. But it still messes up in some cases. For
examply: I have another dimension "Net". If I put it to heading, and
filter by one Net, it shows correct amount of Items. But if I select
two Nets ("select multiple" in excel), then it shows total number, as
if it wouldnt filter by Net at all. Any ideas? =/

distinctcount measures doesn't support multiple filtered members like you
try.

to solve this issue, you have to create a dynamic dcount:
count(crossjoin(items.noitem.members, {measures.simplecount}), excludeempty)


"mrQQ" <algkep (AT) gmail (DOT) com> wrote

Sorry for taking so long to reply.

That's very interesting. I had a suspicion that it wouldnt be
supported.

This example of yours.. What is measures.simplecount in there? Is it
distinctcount(Item.ItemNo.Members)
or is it something else?

thanks!

simplecount is a ... simple count !
take any column in your fact table as a new measure, setup the aggregation
to count, then hide it. you can use an existing count measure if you
allready have one.


"mrQQ" <algkep (AT) gmail (DOT) com> wrote

thanks, i will try it