Forum Discussion
Roym
Helper IV
Helper IVShow only top 8 in table
I have a table visual in my report that has the columns 'Name' and 'Rating'. The column 'Rating' will have values from 1-5. There will be duplicates so you can have multiple 1's, 2's, etc. When I ap...
pls try this
Measure = max('Table'[rating])Measure 2 = max('Table'[Name])rank = rankx(all('Table'),[Measure],,ASC)+rankx(all('Table'),[Measure 2],,ASC)/10rank2 = rankx(all('Table'),[rank],,ASC)then apply the rank 2 in the table visualpls see the attachment below
ryan_mayu
Super User
Super Userpls try this
Measure = max('Table'[rating])
Measure 2 = max('Table'[Name])
rank = rankx(all('Table'),[Measure],,ASC)+rankx(all('Table'),[Measure 2],,ASC)/10
rank2 = rankx(all('Table'),[rank],,ASC)
then apply the rank 2 in the table visual
pls see the attachment below
