Need help

[sameergupta60]

Hi,

I want some help with the below example.

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

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.

Regards,

Sameer 

[Icey]

Hi @sameergupta60 ,

I can find that 29 = AVERAGE(A5:A17). But how is "21" calculated?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@sameergupta60 , You can create a measure or column like

averageX(filter(table, table[value]>= 5 && table[value]<= 45),table[Value])