Forum Discussion
veenashenolikar
3 years agoHelper V
Row Level Security with multiple conditions
Hello, I am facing an issue to setup RLS in my datamodel . The scenario is as follows - I have a security table which enlists information as - (Please note this is sample data) Professio...
visheshjain
3 years agoImpactful Individual
Hi veenashenolikar,
Please refer to this doc USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Also, I can give it a shot, if you can share your sample file.
One more thing, you will need to replace ALL in your Gender column with 2 rows, unless you have the value 'All' in your data as well.
Thank you,
Vishesh Jain
veenashenolikar
3 years agoHelper V
Hi visheshjain ,
I am handling the ALL using a crossjoin with the dimesion table and a custom column.
I will send over the sample file for your perusal
Thanks,
Veena