MAXX/AVERAGEX ignoring some values

[A_a_a]

Hi All,

is there any possibility to calculate the MAXX ignoring some values.

For example:

% max =

MAXX(

    KEEPFILTERS(VALUES('Table1'[Date])),

    CALCULATE([%])

)

I would like to add to that 'ignoring values above 20%'.

Please help.

Thanks,

G.

[v-jayw-msft]

Hi @A_a_a ,

Try this measure:

Measure 2 = MAXX(FILTER(allselected('yourTable'),[%max]<=0.2),[%max])

If it doesn't work, please share some sample data so that we could test the formula.

Best Regards,

Jay