Comparing value from a chart and from a table

[Anonymous]

Hello, 

I work with technicians and I need to analyse their skills.

I'd like to show for exemple people having bad  customer satisfaction with a Chart and display a table with a short list of people having the best  .

What I'm trying to do is : 

if   filtered Customer_Satisfaction  < Customer_Satisfaction of X ( using the same filter  , since i'd like to match people from the same team or at least from the same area ) 

then display X

else Hide X

Here is a small preview of filters , chart and table I need : 

I know I could do a Top N ,  but I 'd like to show only people better than the selected one .

I tried few Dax formula but I don't reach my goal since I not able to compare value from the chart and value in the Table...

Does anybody has a lead ?

TIA  🙂

[daxer-almighty]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[lbendlin · Accepted solution]

You can't do that if the data tables are related.  You need to create a disconnected shadow table with just the technicians' names and then use that table to feed your filter slicer.  Then use SELECTEDVALUE() in your measure to calculate if a particular data point from your data tables should be shown (equal or better than selection) or not (worse than selection)