Forum Discussion
Tabular - Security Filtering Behaviour = None
Hi, I came across "Security Filtering Behaviour = None" in Tabular Editor (both 2 and 3) and initially got excited that it would allow me to solve a specifc use case with RLS in order to leave all d...
How does this work as an explanation. Might be miles off so please shoot it down but works in my head.
When Filtering Behaviour is set to None in the latest example the rows in Person table don't go into the filter context and so COUNTROWS returns 12. However when EVALUATE returns 'Results' it returns only rows present in the expanded table.
If filtering behaviour is left as default (Single) then rows from Person go into filter context and so COUNTROWS and EVALUATE match.
If the relationship is many to many the relationship is limited and so expanded table plays no part.
No, talking to myself but that logic breaks down when other predicates like Test[Test Name] = "Test 1" are thrown into the filter context. Going to ponder on it further.