I have a composite model with heriachical RLS applied. The RLS works perfectly fine except when it comes to using data from the direct query table. I have mutliple tables that are all import and 1 single direct query table.
When using data from the direct query model in a table of data, it totals all values instead of just the values specific to the user viewing per the RLS.
For example, the user will be viewing data for their team. Each user within their team shows the correct number of items however the table total shows the total for all values, not just the values relevant to the user viewing. https://www.linkedin.com/events/c-mocomunicarmeconaviancaenbogo7158716458632384513
