Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
kabra_ashish
Helper III
Helper III

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                 U_DEF                           $200             2

USA                 U_GHI                           $300             3

Germany          G_JKL                            $100             4

Germany          G_XYZ                           $100             5

 

I have the Row-level security implemented in my data model based on country. When the users who have access to only Germany the rank for the customers  appears as G_JKL is 4 and G_XYZ = 5 whereas I want them to be 1 and 2 respectively. It seems that rank does not re-calculate on the basis of row-level security of filters? Instead it takes the entire data.

 

Can someone please help me out here? Basically I am looking the rank to be re-calculated on the basis of row-level security

 

1 ACCEPTED SOLUTION
DataZoe
Microsoft Employee
Microsoft Employee

@kabra_ashish 

 

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

 

rankx.JPG

 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

4 REPLIES 4
DataZoe
Microsoft Employee
Microsoft Employee

@kabra_ashish 

 

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

 

rankx.JPG

 

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

amitchandak
Super User
Super User

Greg_Deckler
Super User
Super User

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.