So i am displaying data wherein i want user to select for how many recent files he/she wants to see data.
So i created one table where i added selection values as shown in below pic
& then i created measure wherein it will store the selected value.
(Selected_N = SELECTEDVALUE('Select_N'[Select]))
Then i created one column wherein it will show true if the value in one of the column is less than or equals the selected value
Column = IF(TEST_TXT_FILES[Rank]<=[Selected_N],TRUE(),FALSE())
This is showing false for all the value even if its satisfying the condition, whereas if i hardcode it like below, it works fine
Top N = IF((TEST_TXT_FILES[Rank])<=10, TRUE(), FALSE())