I want to create a measure in the dashboard with "Manage Roles"

[jesielcarrascos]

Hello everbody,

I need to create an automatic measure with informatics of the "Manage Roles"

The idea is that when the user reads his document on the dashboard, he shows the name through the measure linked to the managed view.

Thanks in advance,

Jesiel

[v-yanjiang-msft · Accepted solution]

Hi @jesielcarrascos ,

If it has many users in the report and you want each user see different content, you should create dynamic Row Level Security, which use the DAX function USERNAME. Here're the steps:

1.Take a simple example, you want Tom see A in Column1 and Jack see B, create a table like below.

2.In Manage roles, add filter on the User Name column.

Create DAX formula

[User Name]=USERNAME()

3.In Desktop, if you want to view roles, select both New role and Other user, then enter the user accout.

It works fine

4.In Service, in the dataset Security tab, add all users to the role.

When Tom@microsoft.com  loged in Service, he will only see A in Column1, when Jack@microsoft.com  loged in Service, he will only see B.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jsaunders_zero9]

Hi @jesielcarrascos

I am afraid this will require a better explanation, maybe some images would help too.

James

[jesielcarrascos]

Of course @jsaunders_zero9 ,

When selecting the view:

The text change will be according to the view selection