Filter rows based on average of unrelated column

[Zabeer]

Hello,

I want to filter rows in table A based on the average of an unrelated column in table B. Both tables are unrelated.
Basically, the logic of filtering should be-
(average of column in table B) <= filtered rows >= (average of column in table B + 10000)

Kindly help. Thank you.

[Anonymous]

Is this not dead easy to do in Power Query?

Best
D

[nandukrishnavs · Accepted solution]

@Zabeer 

SampleTable1

Val
5
6
5
8
9
2
4
1
2

SampleTable2

Val
1
2
3
4
5
6
7

Sample Filter measure

Filter = 
var _avg= AVERAGE(SampleTable2[Val])
var _selectedVal= SELECTEDVALUE(SampleTable1[Val])

var _result= IF(_selectedVal>=_avg&& _selectedVal<=_avg+2,"Yes","No")

//you have to replace 2 with required value. 
return _result

Apply this measure as a visual level filter of the 1st table.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂