Forum Discussion
Helper IIIRANKX in a dynamic table
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
rankx(allselected(Table), calculate(Min[time])) ,,asc)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Super UserAuroraNI , 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
rankx(allselected(Table), calculate(Min[time])) ,,asc)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415