Forum Discussion

timknox's avatar
timknox
Helper II
6 years ago
Solved

Help with a simple Measure

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

Need Help
  • az38's avatar
    az38
    6 years ago

    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

     

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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