We currently have all of our reports with RLS. There is a single report where we would like to include a rank pertaining to how the sales person ranks within the entire enterprise. Is there a way to override the RLS for a single card visualization that would display the sales rep’s overall rank without loading a stagnant table?
Please note that I’m only a few months into Dax and Power BI. I’ve attempted RANKX ( = RANKX( ALL ( ‘Table’ ), [Measure] , , DESC ) however when I test this, every sales rep is ranked #1.
I’ve searched for these topics on YouTube but can’t seem to find anything this specific. I also have not yet completed the online courses so if you could simply point me to a solution, it would be greatly appreciated.