Forum Discussion
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...
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
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 :