Show role name in report

[Djccwl]

Hello community

i have a report that I have created that has a number of different roles applied to control row level security etc. on the report I have a home page with a "welcome [signed in user full]" text at the top but I also want to add the name of the role that the person has been assigned with. I can't find any simple way of doing this. There doesn't appear to be a DAX option unless I'm missing something. 

anyone able to help? 

[Arul]

@Djccwl ,

Do you have role details in your dataset?

Thanks,

Arul

[Djccwl]

Hi @Arul. yes the roles names are based on departments and the department names are in the data set because it's using a column filter to control access to the data. 

[Arul]

@Djccwl ,

then you can just filter down the user logged in and find their role based on USERNAME then concatenate it to the existing measure.

Thanks,

Arul