Use measure as filter for another table

[Anonymous]

Hi 

I have a table which has 3 columns sort 1, sort 2, sort 3 these columns are from 1-100 with different combinations. I have a measure for this table as below 

Speed filter = ROUND(AVERAGE(Sort_combo[sort_1])*(6/100) + AVERAGE(Sort_combo[sort_2])*(19/100)+ AVERAGE(Sort_combo[sort_3])*(27/100),0)

above measure will give value according to the selection from sort 1, sort 2, sort 3, whatever the value it will give the below table should filter accordingly

ex: if I have selected sort 1 = 35, sort 2 = 30, sort 3 = 35 speed filter will give me 15 then in main table should filter where speed is 15

Now, I have a main table as below

Temp	Weight	energy	speed
5	12000	0.23	15
5	12000	1.23	15
5	12000	1.90	15
10	12500	2.89	18
15	12000	3.12	16
15	12000	2.78	16
20	12000	3.12	18

[Anonymous]

Thank you @Jihwan_Kim  It worked!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.