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
thenerv25 , Do for both YTD and prior YTD
Top 10 Rank YTD= CALCULATE([YTD],TOPN(10,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 10 Rank prior YTD= CALCULATE([prior YTD],TOPN(10,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 1 Rank YTD= CALCULATE([YTD],TOPN(1,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 1 Rank prior YTD= CALCULATE([prior YTD],TOPN(1,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))