Forum Discussion
Helper IVisual Level Calculations with RANK
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
Hi,
Please check the below picture and the attached pbix file.
5 Replies
- Jihwan_Kim
Super User
Hi,
Please check the below picture and the attached pbix file.
Pk8524possible 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.
- v-echaithra
Community Support
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. - 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.