Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |