Forum Discussion
Rank function bypasses row level security
Here is a measure version that utilizes that rank column to give you the result when filtered to by RLS to Germany:
kabra_ashish - If Rank is a column, that is correct. Columns calculate at the time of data load and thus are not impacted by dynamic things like slicers or RLS. You need to implement your rank as a measure.
This may help: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
Question, can you use a measure to rank ignoring the RLS applied? To generate this rank table below, but when Germany access only sees rank 4 and 5.
Country Customer_ID Total_Spend Rank
USA U_ABC $100 1
USA U_DEF $200 2
USA U_GHI $300 3
Germany G_JKL $100 4
Germany G_XYZ $100 5