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.
The Team A table below has 3 columns. Column 1 is a Director column that identifies the director of the team A member found in column 2. Column 2 is a column for Team “A” team members. Column 3 is a column that shows who the team A member works with.
Team A Table | ||
Director | Team A Member | Works with Name |
Amy | Carl | Dave |
Amy | Larry | ADAM |
Toney | Mike | Dave |
Toney | Tom | Adam |
Toney | Jerry | KEN |
Sam | Nyra | KEN |
Sam | Felix | Dave |
The organization table below has 2 columns, a column for all members of the organization (this includes members of team A, people team A works with and others) . the second column shows the VP for every member in the organization.
.
Organizational Table | |
VP | Team Member |
Charles | Carl |
Charles | Larry |
Charles | Mike |
Bob | Tom |
Bob | Jerry |
Bob | Nyra |
Stephen | Felix |
Abe | Carl |
Trevor | Larry |
Joe | Mike |
Bella | Tom |
Karen | Jerry |
Mitch | Nyra |
Jarvis | Felix |
I would like to create a Table that shows me a list of all VP’s and has an identifier that says “Y” if any value in the team member column from the organizational table is found in the works with name column of the Team A table, It would say “N” otherwise.
I would also like the ability to filter those results by the Team A director column in the Team A Table.
Can someone help me with a measure?. I have tried to merge the two tables but that doesn’t work because it gives me a Y & N value when VP’s have team members that are both in the works with name column and not on the column
Thanks for your help
If I understand right you :
1) A list of all VP
2) use the related Team Member and look up if the name is found works with name column.
->
VP | Team member | Works with Name |
Charles | Carl | not found |
Charles | Larry | not found |
Charles | Mike | not found |
Did you perhaps mean the Team A Member column?
Than you want to filter the Team A Table, how this should work? I do not understand it. You can filter VP, did you mean this?
Make please a good example with some sample datas 🙂
Proud to be a Super User!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |