Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count where Rank=1

Hi,   I'm looking for a way to make the following analysis work:   There is a slicer with Product selection. When specific products are selected, I need one measure (#customers) to show the numbe...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Anonymous , you might want to try new measures I authored again. (I attached a new file for it)

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, Anonymous , you might want to try new measures I authored again. (I attached a new file for it)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

CNENFRNL,

 

That was it - I could make the CountRank1 work by recreating your '# Customers overlap' logic and inserting condition in there:

IF( [Product rank] = 1, [Product overlap] +0, 0 )

 

Thanks! Appreciate your help a lot.