topic Re: Dynamic Ranking in DAX Commands and Tips

Dynamic Ranking

Ahmad_Jalal — Tue, 16 Sep 2025 18:20:38 GMT

Hi, I need help in making the dynamic ranking. so I've made two field parameters one dimension selection and one for measure selection. now i want to add dynamic ranking column to it so if i select dimension and measure it shows the selected ranking.

Re: Dynamic Ranking

FBergamaschi — Tue, 16 Sep 2025 18:45:07 GMT

this is not possible with a classic measure, unless you write an extremely complex DAX code.

What you can do is using a Visual Calculation.

Here are the results

Please send me a private message and I shall send you the file so yo ucan replicate this, this involved a calculation group, very simple

Best

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: Dynamic Ranking

Ahmad_Jalal — Tue, 16 Sep 2025 19:38:02 GMT

I've Texted you privately can you please provide the code or file

Re: Dynamic Ranking

v-echaithra — Wed, 17 Sep 2025 06:39:46 GMT

Hi Ahmad_Jalal ,

If possible, could you please provide more details about your data?

How to provide sample data in the Power BI Forum

You can refer the following link to upload the file to the community.
How to upload PBI in Community

Thank you.

Re: Dynamic Ranking

v-echaithra — Mon, 22 Sep 2025 07:59:45 GMT

Hi Ahmad_Jalal ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required, please provide sample data. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

Re: Dynamic Ranking

v-echaithra — Thu, 25 Sep 2025 12:12:26 GMT

Hi Ahmad_Jalal ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

Re: Dynamic Ranking

theov — Tue, 14 Oct 2025 13:44:40 GMT

One of the examples in this video is about ranking; https://youtu.be/D_6kPwnByWQ?si=RhfZ2uVSK_5QjjRI