making rank work after applying rls security

[giorgiokatr]

my rank works great but if i use rls tofilter a branch for example make a role to use only branch 2

rank does not work

is there any workaround to make this work?

RankBranchall = RANKX(ALL(Branches);[% Diff.];;ASC;Dense)

[MattAllington]

What do you mean “it does not work?” Do you mean it only works over the sub set of the data visible to the RLS?  If so, I suggest you will need to write the data to a calc column or summary table. 

[giorgiokatr]

thanks @MattAllington

there are 400 branches so without rls rank goes from 1 to 400 (based for example in sales of each branch)

when i use rls branch 2 has only rank 1 beacause it is filtered

is it possible to only be able to see branch 2 (rls ) but calculate the right rank?

[MattAllington · Accepted solution]

Rank works across visible data.

So if there is the following

A 10

B 30

C  5

D  40

Rank will be 

D

B

A

C

If someone can only see A and B, rank will be

B

A

If you want to see the original rank you need to evaluate the ranks and store them in your data model so everyone can see them.  You can do this probably best in a summary table.

[giorgiokatr]

thanks @MattAllington

it is quite difficult to create summary tables as there are many dimensions in my rank report (time,hierarchy, many ranking kpis)

I was trying to find a way to bypass rls for calculating rank

[MattAllington]

RLS is designed to prevent the data being available to those that should not see it. No you can’t get around this.