Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 5 years ago
Hi, Anonymous , you might want to try new measures I authored again. (I attached a new file for it)
amitchandak
Super User
5 years agoAnonymous , in rank you are using 'Prod_selection_1v1'[Product name], same should be used on visuals.
In that case rank 1 count is coming 5,5 what seems right as there are 10 customers.
Anonymous
5 years agoNot applicable
Hi, amitchandak ,
The issue here is - I only need to compare customers which have both products in their assortment. In others words, if at least one Product's VOL = 0, then dismiss this customer.