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
RanKx issue
Hello Everyone , This is regarding the Rankx Function , I have a table which contains data of multiple property i make a measure which gives me rank as per quantity. till the time RLS (Row Level Security) not applied its showing rank the way i want but when RLS applied it shows rank 1 for all the items. below are the formulas which i am currently using : Rank Quantity = IF(HASONEVALUE(Items[Item Name]), RANKX(ALLSELECTED(Items[Item Name]),[Item Sold]))
