CALCULATE MAX and exclude specific rows

[joshua1990]

Hi all!

I have a table that has multiple entries / rows for each article.

Now I would like to get the max value out of a specific column with filtering out specific rows where in a different column specific keys are stored.

Something like this:

CALCULATE(MAX(Table[Value]), WHERE In Column Table[Key]  NOT 'A', 'B' etc.

How would you do that in here?

[wdx223_Daniel · Accepted solution]

=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])

[joshua1990]

@wdx223_Daniel : Thanks a lot! Would you still use this if the table has 5MM rows?