topic Re: Rank Not Working in RLS Security in DAX Commands and Tips

Rank Not Working in RLS Security

Anonymous — Mon, 18 Jul 2022 09:36:30 GMT

hello everyone

my rank works perfect as Admin & as CEO, but if I use RLS Security to filter a region rank does not work, the rank back to number 1.

I use this DAX

Rank = RANKX(ALL('table'),[measure sum])-1

-1 for rank start from 1 (not from 0)

Re: Rank Not Working in RLS Security

amitchandak — Mon, 18 Jul 2022 11:47:29 GMT

Anonymous , Rank Start from 1 only , Try like

Rank = RANKX(ALL('table'),[measure sum])

Re: Rank Not Working in RLS Security

Anonymous — Mon, 18 Jul 2022 12:33:40 GMT

thank you for your information

can you help me to solve this problem? "my rank works perfect as Admin & as CEO, but if I use RLS Security to filter a region rank does not work, the rank back to number 1."

Re: Rank Not Working in RLS Security

Anonymous — Tue, 26 Jul 2022 09:48:56 GMT

Hi Anonymous ,

See if helps:

How to Hack RLS to Make RANK() Work on Entire Dataset

Solved: making rank work after applying rls security

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data