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.

5 Replies

ImkeF
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.