Forum Discussion
Dynamically Group By / Merge Row
Hi All, I have tried to create a model which implements some basic 'Column' level security. Essentially the columns that require security are placed in a seperate table which has some RLS rul...
Kashinoda,
How about you create a calculated column or summarized table instead? Please check the DAX in the modified PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Noky93sU9skg-CUQJ5
Regards,
Lydia
Anonymous
Thanks for your reply, unfortunately a calculated column in the DimProduct table wont work as this will only be populated on process.
Different users will have different access to FactProductConfidential[ProductDescription], this is defined in the 'ConfidentialAccess' table. You can see this yourself by selecting roles 'Everyone' and 'Confidential' and entering 'Other User' as either GHD\mikeshinoda or GHD\janeaustin
Bump