Filtering based on username()

Anonymous — Thu, 31 Jan 2019 08:51:10 GMT

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.

topic Filtering based on username() in Report Server

Filtering based on username()