Forum Discussion

Senthil_Kumar's avatar
Senthil_Kumar
Frequent Visitor
5 years ago

Rank changes when RLS is applied

Hi Team,   I have 3 tables Accountid table (used for RLS) Dealer Master table Fact sales tables   I am showing ranking of dealers based on their sales quantity. I also want to apply RLS in my...
RANKX
RankX issue with RLS
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Senthil_Kumar 

 

I'm not 100% sure but I think it's not possible. When you apply RLS, it means that the current user CAN'T SEE data rows that get filtered out. It also means that DAX just excludes the filtered out rows from any analysis---it treats them as if they are just not there. You can't through DAX "unhide" the rows for the duration of the calculation.

 

Think about it this way. If you have 2 countries, the USA and the UK, and the user has only permissions to view data that belongs to the USA, then there is no way to somehow hack into data from the UK.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello,

I also have same scenario and couldnt achieve it and not sure if it is doable. Just trying to understand if you were able to achieve the expected result. If yes, could you please post the solution steps.