topic Re: Filter rows based on average of unrelated column in DAX Commands and Tips

Filter rows based on average of unrelated column

Zabeer — Wed, 29 Apr 2020 11:07:27 GMT

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.

Re: Filter rows based on average of unrelated column

nandukrishnavs — Wed, 29 Apr 2020 12:18:34 GMT

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 🙂

Re: Filter rows based on average of unrelated column

Anonymous — Wed, 29 Apr 2020 13:08:21 GMT

Is this not dead easy to do in Power Query?

Best
D