Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |