Forum Discussion
Rankx function didn't work well when introduce a column from another table
I have a table visual that shows Rank columnName by countofReports RANKX(ALLSELECTED(Table[ColumnName]),CALCULATE([Count])) This work fine but when I introduce another column Type from d...
Anonymous , measure rank is based on row context. So if add any other column than what you used in Rank, Rank it will readjust itself inside that additional column
so you need like
RANKX(ALL(Table[ColumnName], Table[Type]),CALCULATE([Count])) or RANKX(summarize(allselected(Table), Table[ColumnName], Table[Type]),CALCULATE([Count]))
amitchandak
Super User
Super UserAnonymous , measure rank is based on row context. So if add any other column than what you used in Rank, Rank it will readjust itself inside that additional column
so you need like
RANKX(ALL(Table[ColumnName], Table[Type]),CALCULATE([Count]))
or
RANKX(summarize(allselected(Table), Table[ColumnName], Table[Type]),CALCULATE([Count]))I have tried the two measures and it is not working . it returns the same result as my rankx measure.
I need it to rank only on Columname in the table visual. help please