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 dataset since there are user who have access to particular dealers data only, but when I apply RLS the ranking is calculated on the filterted data instead of whole set of data. This is the ranking of dealer when RLS is not applied When RLS is applied on account id : 2347, below is the result But my intended result should be rank for dealer A should be 2 and for dealer F 5. Even though dealers get filtered due to RLS, Rank should be calculated based on All dealer. Note: I cannot hardcode rank using a calcualted coulmn as I have date slicer and rank will change when date slicer is used. I have attached the pbix with sample data below. Sample PBIX
