Visual Level Calculations with RANK

[Pk8524]

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 

[v-echaithra]

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.

[v-echaithra]

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.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

[Pk8524]

possible to hide rows with no data?

[Jihwan_Kim]

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.