topic Re: Visual Level Calculations with RANK in DAX Commands and Tips

Visual Level Calculations with RANK

Pk8524 — Tue, 14 Oct 2025 15:38:38 GMT

I am trying to make a ranking using visual level calculation:

I would like to use visual level calculations and have properly calculated rank for products in certain country: meaning ranking should reset for each country and start from 1, 2, 3 etc. Is it possible to achieve?

Secondly would like to have a parameter which will be showing all products with rank <= parameter.

I know i can achieve this with dax and measures - but wonder if this solution with visual level calculations i could scale to a bigger projects and improve performance.

Testing file:

https://drive.google.com/file/d/1_6YkUkjpuEDlVF_2z87XT-E6JUVrODj-/view?usp=sharing

Re: Visual Level Calculations with RANK

Jihwan_Kim — Tue, 14 Oct 2025 17:15:16 GMT

Hi,

Please check the below picture and the attached pbix file.

Re: Visual Level Calculations with RANK

Pk8524 — Tue, 14 Oct 2025 20:30:36 GMT

possible to hide rows with no data?

Re: Visual Level Calculations with RANK

Jihwan_Kim — Wed, 15 Oct 2025 02:45:26 GMT

Hi,

I checked the documentation below,

Considerations and limitations

desktop-visual-calculations-overview#considerations-and-limitations

And, I don't think there is a way to turn off "Show items with no data" option at this moment.
Or, please correct me if I mis-understood.

Thank you.

Re: Visual Level Calculations with RANK

v-echaithra — Thu, 23 Oct 2025 07:28:53 GMT

Hi Pk8524 ,

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. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

Re: Visual Level Calculations with RANK

v-echaithra — Mon, 27 Oct 2025 16:09:12 GMT

Hi Pk8524 ,

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.