Need help with RLS

[AbbasG]

Hello there,

I have set up RLS on the sales report where the salesperson only sees his/her data.

I have created the cards showing today's and yesterday's sales, where each salesperson can see their respective figures.

But, I also want to display the total sales made by the company i.e. today's and yesterday's sales.

End result - The salesperson will see the individual sales amount as well as the total sales by the company.

Please let me know how do I achieve it?

[DataInsights · Accepted solution]

@AbbasG,

One idea would be to create a table that calculates total company sales for today and yesterday. You could do this in a DAX calculated table or Power Query (you could use the TODAY function in DAX or the M equivalent to get the current date). This table would not be subject to RLS. Total company sales would be based on this summarized table, and thus all users would be able to see it.

[DataInsights · Accepted solution]

@AbbasG,

One idea would be to create a table that calculates total company sales for today and yesterday. You could do this in a DAX calculated table or Power Query (you could use the TODAY function in DAX or the M equivalent to get the current date). This table would not be subject to RLS. Total company sales would be based on this summarized table, and thus all users would be able to see it.

[AbbasG · Accepted solution]

@DataInsights thank you so much. Got the job done!