Need help

Question

Hi,&nbsp;I want some help with the below example.&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;22&nbsp;&nbsp;&nbsp;&nbsp;27&nbsp;&nbsp;&nbsp;&nbsp;45&nbsp;&nbsp;&nbsp;&nbsp;155includeAvg:- 29&nbsp;&nbsp;15excludeAvg:- 21range5 to 4514&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;22&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;&nbsp;21&nbsp;&nbsp;&nbsp;&nbsp;23&nbsp;&nbsp;&nbsp;&nbsp;21&nbsp;&nbsp;&nbsp;&nbsp;25&nbsp;&nbsp;&nbsp;&nbsp;23&nbsp;&nbsp;&nbsp;&nbsp;26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;in the above example, I want to define the range to calculate the avg in between 5 to 45.whatever number range between 5 to 45 only those number average should be calculated.&nbsp;Regards,Sameer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Answer

sameergupta60 , You can create a measure or column like 
averageX(filter(table, table[value]&gt;= 5 &amp;&amp; table[value]&lt;= 45),table[Value])

icey · Answer

Hi&nbsp;sameergupta60&nbsp;,
&nbsp;
I can find that 29 = AVERAGE(A5:A17). But how is "21" calculated?
&nbsp;

&nbsp;
Best regards
Icey
&nbsp;
If&nbsp;this post&nbsp;helps,&nbsp;then consider Accepting it as&nbsp;the solution to help other members find it faster.
&nbsp;

Forum Discussion

Need help

2 Replies

10
22
27
45
155	include	Avg:- 29
15	exclude	Avg:- 21	range	5 to 45
14
10
22
15
14
21
23
21
25
23
26