Filtering data on selected language

Hi Boeboey ,

Thanks for reaching out to the Fabric community.  You’re good, and We appreciate you sharing details along with snapshots they make troubleshooting much easier. We  wanted to build on your approach and address the challenges you mentioned regarding RLS  and filtering.

1. Since RLS prevents users from pinning visuals to dashboards, you might want to reconsider using it for this scenario. Instead, a better approach would be to dynamically filter translations without RLS.

2. To do this, you can create a measure or calculated column that pulls the correct translation from the Safety Codes table based on the Selected Language measure. This method ensures flexibility and keeps your reports dynamic.

3. Your data relationships are structured correctly! Keeping Department and Function separate enables independent lookups for each, which works perfectly with your unpivoted Safety Codes table.

I hope this helps..