Forum Discussion
Row level security information to textbox
tuulia , if organization and department are from different tables , we can use a measure from fact to make sure we use security , say measure is Fact measure
maxx(filter(values(department[name]),not(isblank([Fact measure]))), [name])
else
can share data model and RLS filters
tuulia , Try a measure like and use that in tile or card visual
maxx(allselected(organization), [organizationcode])
concatenatex(allselected(organization), [organizationcode])
Thank you. I have allready tried allselected-functions but it returns all departments available in dimension. Users do not select anything from organizationslicer, row level security handles all filtering of data.
tuulia , if organization and department are from different tables , we can use a measure from fact to make sure we use security , say measure is Fact measure
maxx(filter(values(department[name]),not(isblank([Fact measure]))), [name])
else
can share data model and RLS filters
This works, thank you very much!
