Trying to Summarize and Rank the results

[MRUry7]

Hi, I'm trying to rank my items in the first 2 columns by the result position, so i can get a count of how many times an item in the query column was found in results position1, 2, etc.
Very easy in excel, very challenging for me in PowerBi.  Can some help me with finding a solution to this? The query column is an item from a slicer that the user chooses.
In the example below, the detail is on the left two columns and the results are on the right if a user chooses Item1, Item2, etc.

Any help is appreciated.
Thank you 
Steven

[mh2587]

Please accept my solution if it helps you

[mh2587]

Item Rank = 
RANKX(
    FILTER(
        YourTableName,
        YourTableName[Query Column] = SELECTEDVALUE(QuerySlicer[Item])
    ),
    YourTableName[Result Position]
)

[MRUry7]

Hi, and thanks for your help. When a user chooses something, that's pretty easy.  But what if you just want to rank values in a table, something like this?

Is there a way to do this without having to use the SUMMARIZE function, to create a new table?

[MRUry7 · Accepted solution]

Thanks very much. It worked and I was able to adapt it for other measures