Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm have two tables in my data set
manager | user 1 |
manager | user 2 |
manager 2 | user 3 |
manager 2 | user 4 |
manager 2 | user 5 |
and
user 1 | a |
user 2 | b |
user 3 | a |
user 4 | a |
user 5 | a |
I need to create a report view that will show me the Manager value in the first table, only for values where i have multiple options in the second table.
So in the case of the tables above i want to see the value for manager because user1 and user 2 have values a and b.
I don't care about Manager 2 as their associated users all have value a.
I already created a table relationship using the user column in the first table as the primary key.
I'm not really sure how to ask the question for a google search on this one so hopefully someone can point me in the right direction.
Solved! Go to Solution.
Hi,
You may download my solution from here.
Hope this helps.
Hi,
You may download my solution from here.
Hope this helps.
Thanks Ashish your solution seems to work best for my needs.
You are welcome.
@powerbinoob457,
Please review the calculations in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NojkJOHcLiVIZAgsu7
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |