Show If As Security Filter Idea

I had an idea to simplify views columns etc being filtered.  Before I go down the road of setting it up I would like to know if I am wasting my time so any insight on flaws or "Cant do thats" are appreciated.  I think this will help computational load too.

I have started with something along these lines -

OR(Contains(Any(select(Usr_Access[Security Level], Useremail()=[useremail])), "Project Manager"),Contains(Any(select(Usr_Access[Security Level], Useremail()=[useremail])), "Administrator"))

But I was thinking instead to simplify it as each user will need acces to multiple groups of things that if I created a virtual column that contains the value of the users access levels from my usr table, to use a show if "Contains([Virtual Column], "Project Manager").  My only concern is for views, does the VC calculate with regard to a specific view, like a project manager dashboard?  Or will it only be relevant for the show ifs directly in regard to data, ie. column shof ifs or row security filters?

 

Thanks appreciate any input!

0 2 65
2 REPLIES 2
Top Labels in this Space