Forum Discussion
Top Performer Comparison
https://drive.google.com/file/d/1VRaQzLoF4WUswZceW9gZx5T-aqHOqHxJ/view?usp=sharing
use this file and see whether it works. Actually when you apply an external filter,
The Data gets restricted and only shows the filtered data hence other one will not show up.
Another way (if above file is not useful) To Show that value you need to create another visual Like Card and restrict the interaction so taht the card will show the Top Value
Very helpful, thank you so much. The one hangup seems to be that the slicer on the dashboard that is used to select the employee is also seemingly limiting the employees in the ranking data set. In other words, each person that is selected becomes the #1 ranked and thus their metrics are duplicated for the top performer measure. Is there a way around this?
To make sure I translated the solution correctly, I created 2 measures and used the 2nd (RankReturn) in the visual. Account Manager is the employee and Act YTD Activity Count is the metric i am attempting to rank on.
RankReturn = Calculate([Act YTD Activity Count], filter(all('DIM Account Manager'[Account Manager]),[RANKOFEMPLOYEES]=1),Distinct(Account Manager))
Just add the highlighted one
VijayP
Unfortunately I am still getting the same outcome. I have added a couple of visuals below for 2 different employees to add clarity to the challenge. Endorsements, ARS, and RMS are just types of actions that we are doing a distinct count on. Thanks again for taking the time to help me with this.https://drive.google.com/file/d/1VRaQzLoF4WUswZceW9gZx5T-aqHOqHxJ/view?usp=sharing
use this file and see whether it works. Actually when you apply an external filter,
The Data gets restricted and only shows the filtered data hence other one will not show up.
Another way (if above file is not useful) To Show that value you need to create another visual Like Card and restrict the interaction so taht the card will show the Top Value