Forum Discussion
Filtering based on Username()
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
Hi Anonymous,
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
1 Reply
- v-danhe-msftMicrosoft Employee
Hi Anonymous,
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