Forum Discussion

Frequent Visitor

7 years ago

Solved

Select max value in column based on another column

I am looking to select the Max value in eip_value based on the key column. How do I write a Dax function to do this?

Tips and Tricks

ImkeF
7 years ago
You could write it like so:

CALCULATE(MAX('Table'[eip_value]), ALLEXCEPT('Table', 'Table'[Key]))

Please make sure to use that in the data view, as it is a DAX-function.

Community Champion

7 years ago

Do you want it as a column or a measure?

AOT
Frequent Visitor
7 years ago
Hi,

I want it as a column, thanks
- ImkeF
  Community Champion
  7 years ago
  
  You could write it like so:
  
  CALCULATE(MAX('Table'[eip_value]), ALLEXCEPT('Table', 'Table'[Key]))
  
  Please make sure to use that in the data view, as it is a DAX-function.
  - AOT
    Frequent Visitor
    7 years ago
    This worked. Thank you.