Help with a simple Measure

[timknox]

Hi all,

I need help with [what i think is] a simple measure.

Basically i have a data file, and one of the columns is called EC.  An example is as below:

EC
2019
2019
2020
2018
Outturn
Outturn
2020
2016
2020
2019
2019
2020
2018
Outturn
Outturn
2020
2016

The measure I am after is to select the highest number in the column, ignoring the word 'Outturn'

Basically the answer should be 2020

Thanks for your help

[az38 · Accepted solution]

Hi @timknox 

Measure = calculate(MAX('Table'[EC]),'Table'[EC]<>"Outturn")

do not hesitate to give a kudo to useful posts and mark solutions as solution

[timknox]

thanks