I have a couple of calculated fields that uses PRE_FILTER
Basically I use this fields to get:
Service_Cost_Total >> minOver({Total_Services_Cost}, [day], PRE_FILTER)
and
Support_Cost_Total >> sumOver({GD Support}, [day], PRE_FILTER)
Then I use both on a single formula that I have as a column in a table
Support Total >> ({AccountSupportCost}*{Service_Cost_Total})/{Support_Cost_Total}
the dashboard contains a lot of different ‘Account’, so in my view the ‘Support Total’ calculation shows correctly because I can access all ‘Account’.
But the issue is that I use RLS so the individuals can see only the ‘Account’ they belong to, and for ‘Support Total’ they are not seeing the correct total, looks like that they have the Service_Cost_Total.
I am not very familiar with this PRE_FILTER / PRE_AGG calculations, but it worked on my view so I need to understand how make this to work for the users viewing this dashboard
You may refer to the following article that explains the Level Aware Calculations in detail.
Coming to your question the RLS restricts access to data and that will happen before any other computations since the objective of security is to only give access to what the user should see. The Total from that persective of the Total for data the user has access to.
So, for example if I have access to Country India my total will be only for India though my dataset has data for Regions Europe, Asia and Africa. The person who should have a global view and has access to all data will see the overall total.
The PRE_FILTER and PRE_AGG have no role to play in the row level restrictions.