Dynamic Ranking

[Ahmad_Jalal]

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.

[FBergamaschi]

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

[Ahmad_Jalal]

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

[v-echaithra]

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.

[v-echaithra]

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.

[v-echaithra]

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.