Make slicer of topN rows that have same value

[zahra]

I have table with 30 column and 200 rows. IN 'prob' column (1) value repeated 66 times and (2) repeated (30) times, how  i can make slicer based on top100 . means make slicer that when i put on 100 choose only 66 first row of that comtain 1 and 34 row that contain number of 2 .  I used of RANKX for make ranking but still i have 66 number 1 and t rank 67 for first time that 2 appear.

[v-lili6-msft]

Hi @zahra

You can try to add restriction when using rankx :Dense

Measure = IF(HASONEVALUE(Table2[Prob]),RANKX(ALL(Table2),Table2[Prob],VALUES(Table2[Prob]),ASC))

Measure 2 = IF(HASONEVALUE(Table2[Prob]),RANKX(ALL(Table2),Table2[Prob],VALUES(Table2[Prob]),ASC,Dense))

Result:

If it is not your case, please share pbix or some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[zahra]

Thanks. But i need somethings like this. index column should be dependent to rank_probility

[v-lili6-msft]

hi,@zahra

By your description ,if you want to rank even if the values are same ? You can try to use Edit Queries -> Add column ->Index Column function

Step1:

Click Edit Queries and Sort Ascending the Prob column

Step2:

Click Index column (create a new column with an index column starting at 0, you can also custom start at any number)

Step3:

Click Close & Apply and you will get the result

If it is not your case, Would you like to achieve the result by RANKX ? or please describe the expected output in detail.

Best Regards,

Lin