RANKX in a dynamic table

Question

Hi all,I have had a look on some of the other posts around this and also on youtube but can't get my RankX to do what I need it to do so would be grateful for some assistance.&nbsp;I have a simple table where I want to rank runners based on time and be able to use a slicer to select different events.&nbsp; I want the rank to rank the runners 1-8 for the race selected in the slicer as shown below&nbsp;However when I select another event it ranks it based on the whole table rather than the selected one as I want to still rank it 1-8 for this event:My current code for the Rank is:I have looked in the forums which suggest using 'AllSelected' and/or 'Filter' but I cannot get it to work and I know it is a simple solution.&nbsp;Thanks for any assistance.&nbsp;

amitchandak · Accepted Answer

AuroraNI , What you are creating a column Rank. For it to be dynamic you need measure rank. measure rank requires a rank.
So might have to convert this time in duration in min or sec and use it. or use min/max and use it
&nbsp;
rankx(allselected(Table), calculate(Min[time])) ,,asc)
&nbsp;
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Forum Discussion

RANKX in a dynamic table

1 Reply

Related content

RankX

Dynamic Table Creation???

Advanced Ranking (Rankx)

Dynamic RANKX

Dynamic ranking use RANKX() show duplicates