Hi all,
I am currently setting up the security matrix for my SSAS tabular models. My company has alot of products by brands. Each product teams are allowed to view their own brand product. However for management level, they should see all. How do I setup the management level people to see all? Do I really need to list down all the product brands which are up to thousands?
User A - Brand ABC
User B - Brand DEF
User C - Brand DEF
User D - ALL <- All brands
How should I setup my security matrix table and also the DAX filter to achieve the said result.
Thanks!
Max.
