Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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 🙂
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 🙂
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |