Top N slicer define issues

[GAPER]

Hi all - i am following the instructions here 

https://blog.magnetismsolutions.com/blog/colinmaitland/2022/05/13/how-to-configure-a-top-x-slicer-in...

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

[toziu]

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.

[GAPER]

Any reason it's still showing like this...Thanks!

[toziu]

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. 

[toziu]

i can't find the mistake,maybe you can send a private message to me

with your all tables and functions.

[GAPER]

Sorry for any confusions. 

Rank (renamed as value) = GENERATESERIES(10,100,5)

Selected Rank = SELECTEDVALUE('Rank'[Value],100)

is selected customer rank (exposure) = 
VAR _borrower_rank = [Borrower Revenue]
VAR _selected_rank = 'Rank'[Selected Rank]
RETURN
    IF (
        AND ( NOT ISBLANK ( _borrower_rank ), NOT ISBLANK ( _selected_rank ) ),
        IF ( _borrower_rank <= _selected_rank, 1, 0 ),
        0
    )