Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
3 years ago
Solved

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?

2 Replies