Forum Discussion

kabra_ashish's avatar
kabra_ashish
Icon for Helper III rankHelper III
6 years ago
Solved

Rank function bypasses row level security

Assuming I have the below table with the rankings:   Country         Customer_ID         Total_Spend      Rank USA                 U_ABC                          $100             1 USA           ...
  • DataZoe's avatar
    DataZoe
    6 years ago

    kabra_ashish 

     

    Here is a measure version that utilizes that rank column to give you the result when filtered to by RLS to Germany:

     

     

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

kabra_ashish 

 

Here is a measure version that utilizes that rank column to give you the result when filtered to by RLS to Germany: