Forum Discussion
joshua1990
3 years agoPost Prodigy
CALCULATE MAX and exclude specific rows
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?
=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
2 Replies
- wdx223_DanielCommunity Champion
=MAXX(FILTER(Table,NOT(Table[Key] IN {"A","B"})),Table[Value])
- joshua1990Post Prodigy
wdx223_Daniel : Thanks a lot! Would you still use this if the table has 5MM rows?