Need Help

[sameergupta60]

hi 

in the below example Matri table, I want the avg range between 5 to 45. please suggest the formula.

in the below example it includes all column data & generates Avg.  

Another example is given below

1	13	13
2	15	15
3	21	21
4	21	21
5	28	28
6	48
7	93
Avg	34	19.6

Regards,

Sameer 

[v-alq-msft · Accepted solution]

Hi, @sameergupta60 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Result = 
IF(
    ISINSCOPE('Table'[Category]),
    SUM('Table'[Val]),
    AVERAGE('Table'[Val])
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sameergupta60 , Try like

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