Row level security information to textbox

[tuulia]

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

[amitchandak]

@tuulia , Try a measure like and use that in tile or card visual

maxx(allselected(organization), [organizationcode])

concatenatex(allselected(organization), [organizationcode]) 

[tuulia]

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.

[amitchandak · Accepted solution]

@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]

This works, thank you very much!