Forum Discussion
Top Users matched to Distinct Companies Amongst Projects
Hi,
Thanks in advance for any and all help with this!
I have a table of Projects. Each Project has a Company, a Manager, and a Company Contact. Each Company, Manager, and Contact can be attached to multiple Projects. I'm trying to find the Top Manager and Top Contact per Company based on how many times they appear as the Manager or Contact on that Company's Projects. Here's and example of what I'm looking for.
| Project | Company | Company Contact | Manager |
| A | Farmers | Bill A. | Frank |
| B | Mazda | Monica M. | Jerry |
| C | GE | Terry P. | Laura |
| D | Mazda | Monica M. | Laura |
| E | Mazda | Monica M. | Laura |
| F | GE | Terry P. | John |
| G | GE | John G. | John |
| H | Farmers | Gill S. | Mark |
| I | Farmers | Bill A. | Mark |
I want to take these results and build them into a new table or display as:
| Company | Top Contact | # of Times as Primary Contact | Top Manager | # of Times as Manager |
| Farmers | Bill A. | 2 | Mark | 2 |
| Mazda | Monica M. | 3 | Laura | 2 |
| GE | Terry P. | 2 | John | 2 |
How would I accomplish this?
HI
Attached PBIX has working solution. Create [top contact ct], [manager ct] to add in the table and [Rank_Filter_VisualLevel] to add as a visual filter.If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!Make it reflex,
2 Replies
HI
Attached PBIX has working solution. Create [top contact ct], [manager ct] to add in the table and [Rank_Filter_VisualLevel] to add as a visual filter.If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!Make it reflex,