Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |