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!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |