Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Comparing value from a chart and from a table

 

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  🙂

  • lbendlin's avatar
    lbendlin
    5 years ago

    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)

2 Replies