Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Use RANKX with column ID or column not calculated

Hello everybody, I would like to know if I can use RANKX function with column ID or column not calculated ? If not, is there a solution to display the first ten rows of this table (knowing that I tri...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I would simply like to display the first 10 rows of this table

 

 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Top 10 based on any measure would be like this

Top 10 Rank = CALCULATE(calculate(countrows(Table)),TOPN(10,all(Table[id]),calculate(countrows(Table)),DESC),VALUES(Table[Id]))

 

Else top 10 based just ID column rank, you have a filter at the visual level

Rankx(all(Table), [ID],,asc)

 

Here we need the basis of top 10 filter

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandakI used the first formula as you indicated to me, but it still shows me all the lines

    at first, I created a measure like this :

    IDN3 = CALCULATE(CALCULATE(COUNTROWS(Tracking)),TOPN(10,FILTER( Tracking, Tracking[IsInPeriode] = 1 &&Tracking[glpi_dropdown_tracking_category.name] = "Incidents" && Tracking[priority] = 4) ,calculate(countrows(Tracking)),DESC),VALUES(Tracking[Id]))

     

    ana i had this result :