Rank based on filter

[mnsn]

Hello, I am trying to change the order of my table.  I have imported data from Peloton Wellview, have filtered (Basic Filtering) so that I only see selected fields.  I would now like to change the order i am looking at them.  Any ideas?

Many thanks

Jenny

[v-chuncz-msft · Accepted solution]

@mnsn,

You may use RANKX Function to add a measure.

http://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491