Forum Discussion
Use measure as filter for another table
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 |
Hi,
Please check the below picture and the attached pbix file.
2 Replies
Thank you Jihwan_Kim It worked!
- Jihwan_Kim
Super User
Hi,
Please check the below picture and the attached pbix file.