topic CALCULATE MAX and exclude specific rows in DAX Commands and Tips

CALCULATE MAX and exclude specific rows

joshua1990 — Fri, 13 Jan 2023 06:18:07 GMT

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 — Fri, 13 Jan 2023 07:23:32 GMT

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

joshua1990 — Fri, 13 Jan 2023 09:13:00 GMT

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