Filtering based on Username()

[mlo]

Hi,

Currently I have some challenges with filtering based on username().

I have two tables: Employees and Userinformation.

The Userinformation table contains different usernames and Employees contains different profiles.

What I need: If the username is present at the Userinformation table, then I want to show all profiles from the Employees table. If not, then show no results.

I am fairly new to DAX, so it might be a simple problem.

Thanks in advance

[v-danhe-msft · Accepted solution]

Hi @mlo,

Could you mean you want to ues the USERNAME() to filter different data? If so, you could refer to below blog:

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Regards

Daniel He