Forum Discussion
Top N slicer define issues
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.
Any reason it's still showing like this...Thanks!
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.
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 )