Forum Discussion
Top N slicer define issues
Hi all - i am following the instructions here
I am having some issues at the step 2 and 4
step 2
I created the step 2 as shown. But it only has 1 single drop down of 100 (instead of 1 - 100)
here is my value column
Is it because my default value for Value is summed?
Step 4
You could see that my revenue ranked is set up properly but the rank Step 4's logic is all at zero now.
Thanks a lot in advance.
Best,
Roger
5 Replies
the first problem is simple.
selectedvalues([value],100) means that if Values are not unique，if will return 100, now you don't filter your [value],so it's value is from 1 to 100, so the function will return 100
You should put [value] in the slicer, here i choose 5, [value] has only one value,
so the selectvalue() will return 5,not 100
and the rank <=5,will return 1 ,just likes the picture.
can i see your all function?now i can't know the answer of your second question.
i have tried this ,it work well.In slicer , i choose [value]=30,so the selectedvalue() in the card also shows 30
try to Put rank[value] and selected rank in the matrix.if your function is right,it would be the same as the [value],just like the picture.
maybe you should show me all of your table and your function.
the picture you replied i think is right.
