Forum Discussion

Katerina_SL's avatar
Katerina_SL
Icon for Helper II rankHelper II
3 months ago
Solved

RLS using

Hello Everyone! Could someone please help me with such issue: I have a Power BI report that tracks Salesman Performance, including KPIs such as profit, number of orders, number of clients by stat...
Need Help
  • Gabry's avatar
    Gabry
    3 months ago

    Hello Katerina_SL ,

    I think one solution could be to create a pre-aggregated table that contains the global totals but does not contain the user_id or salesman_id or anything related to user / salesman. So, because the user ID is missing, you won't apply RLS to this table, allowing everyone to see the global totals . It's better if you do this using power query. Of course then you should build the total measures on this pre-aggregated table
    Hope this helps you 😉

Gabry's avatar
Gabry
Icon for Super User rankSuper User
3 months ago

Hello Katerina_SL ,

I think one solution could be to create a pre-aggregated table that contains the global totals but does not contain the user_id or salesman_id or anything related to user / salesman. So, because the user ID is missing, you won't apply RLS to this table, allowing everyone to see the global totals . It's better if you do this using power query. Of course then you should build the total measures on this pre-aggregated table
Hope this helps you 😉