Forum Discussion

mmanwaring's avatar
mmanwaring
Resolver I
10 years ago
Solved

RLS - creating a measure to overide RLS

Hi All   I have added RLS to a test dashboard.   My aim is to create a dashboard and share with a number of users. Each user will have data restriced to their sales only!   i have been asked as...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    mmanwaring

    As per the online document Row-level security, the RLS filter the dataset directly. So I don't think your approach would ok.

    In your case, to see a KPI against the top sales person in the condition that each user only has data restriced to their sales only, I think you can use a custom column storing the top sales.

    TotalSalesForEachSaler = CALCULATE(SUM(Listings[sales]),FILTER(Listings,Listings[salerid]=EARLIER(Listings[salerid])))

TopSales = MAXX(Listings,Listings[TotalSalesForEachSaler])

     

    If you have any question, feel free to let me know.

Ermin's avatar
Ermin
Advocate II
9 years ago

Hi mmanwaring,

 

I have a similar issue with my multitenant Power BI dashboard.

 

Here is the link to my question:

http://community.powerbi.com/t5/Desktop/Power-BI-Embedded-and-multitenant-support/m-p/97576#M41109

 

There are also various answers on how to handle this topics. However, it looks like there is no standard solution to these kind of problems. 

Microsoft would need to catch up here because the whole effect of comparing my KPIs to the other is missing within RLS. 

 

In case you find a solution for this please keep me in the loop.