Forum Discussion

aolan's avatar
aolan
Frequent Visitor
3 years ago
Solved

Get the equivalent value in another column

Hi,   I have a table with a list of scores and their corresponding percentage. I want to get the score that corresponds to [at least] 80%. For example, since there is no score that is exactly 80%, ...
  • Shaurya's avatar
    Shaurya
    3 years ago

    Hi aolan,

     

    Use this DAX Code:

     

    Measure = CALCULATE(MIN('Table'[Value]),FILTER('Table','Table'[Score]>80))

     

    Result:

     

     

    Works for you? Mark this post as a solution if it does!

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
3 years ago

Hi aolan,

 

Use this DAX Code:

 

Measure = CALCULATE(MIN('Table'[Value]),FILTER('Table','Table'[Score]>80))

 

Result:

 

 

Works for you? Mark this post as a solution if it does!

  • aolan's avatar
    aolan
    Frequent Visitor
    3 years ago

    I had to modify the DAX a bit but it is essentially what I needed, thanks!