Forum Discussion

sumanthkakarla's avatar
sumanthkakarla
Helper II
1 year ago
Solved

How to filter dimension based on Dynamic RLS applied to another dimension

I have this below data model where i have implemented Dynamic RLS, however the three visual filters are getting populated from Fact table which is taking lot of time to load the filters, to get rid o...
Need Help
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    Hi sumanthkakarla , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
    Thank you.

sumanthkakarla's avatar
sumanthkakarla
Helper II
1 year ago

Thank you v-hashadapu 

I can't create a relationship between user access table and the dimension tables based on username as the dimension tables will have only relevant data and no username exists in any of those dimensions.

To overcome this, i have created a dax formula on all those newly created dims and its working as expected, i have to see the performance though.

v-hashadapu's avatar
v-hashadapu
Community Support
1 year ago

Hi sumanthkakarla , Thanks for the update. Please do let us know, how it is working and if it is performing without any issues, please mark the helpful answer 'Accept as Solution', so others with similar issues may find it easily. Thank you.