Forum Discussion

mattcha's avatar
mattcha
Regular Visitor
2 years ago
Solved

Using measures to filter another table

Hi everyone! Many thanks in advance if you can help me with my problem. I have a "stats" table which contains players' info & stats for each season. I created a first slice on the "name" in order to...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mattcha ,

     

    According to your description, here are my steps you can follow as a solution.

    (1) My test data is the same as yours.

    (2) We can create a table and a measure. 

    Table 2 = 'Table'
    Flag = 
var _position=CALCULATE(MAX('Table'[position]),ALLSELECTED('Table'))
var _age=CALCULATE(MAX('Table'[age]),ALLSELECTED('Table'))
var _season=CALCULATE(MAX('Table'[season]),ALLSELECTED('Table'))
return IF(AND(AND(MAX('Table 2'[position])=_position ,MAX('Table 2'[season])=_season),OR(MAX('Table 2'[age])=_age+1,MAX('Table 2'[age])=_age-1)),1,0)

    (3) Place [Flag=1] on the visual object filter and then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can you give another example? From my understanding you want to select players that all have the same criteria? Why don't you just user different slicers if that is the case?

mattcha's avatar
mattcha
Regular Visitor
2 years ago

Hi Anonymous , thanks for answering. 
I tried to simplify for the example but some of the criteria would be a bit different and specified in the formula, ex:
-age of similar player +/- 1 year
-I have also a score variable and final goal is to rank the new table with the lowest difference between player selected by the user and the similar ones (MIN of ABS("score of filtered player - score similar ones))

Basically, I'd like my graph Dashboard to be the easiest for the user, so only one slicer (=name of the player) if possible. 
If it's not possible, I will simply create a new table with new slicers based on age, position, latest season and a calculated column for the score difference.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    What do your tables look like?