Forum Discussion
Row level security information to textbox
Hi! Report users can see only data related to their own organization part (marketing sees marketing data, sales sees sales data etc) via row level security. How can I create dynamic title/texbox where this organization level/part is shown?
For example: user from sales-department opens report -> title/textbox shows "Sales department". User from marketing-department opens report ->title/textbox shows "Marketing department"
All organization data is in Dimension and row level security uses "organizationcode":
orgazationcode 100000 Sales
orgazationcode 200000 Marketing
orgazationcode 300000 IT
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
4 Replies
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
