Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Max value from another column based on row value

I'm trying to write a DAX function to find the maximum value in one column based on a condition in another, but have this condition change dynamically based on the row value.   With this code...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Anonymous

     

    Try this

     

    =
CALCULATE (
    MAX ( RankOfArea[count] ),
    ALLEXCEPT ( Rankofarea, Rankofarea[Line] )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair,

 

Oh sorry, that was me assuming - I saw you were a power user !

 

Must've been admin. Anyway cheers again for your response - didn't understand it but it worked :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Cheers I'll take a look. I was watching AF's introductory video last night.

     

    It's perhaps the CALCULATE bit I don't get but possibly trying to run before I can walk..

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    So the line:

     

     ALLEXCEPT( RankOfArea, RankOfArea[Line] )

     

    creates a reference to a different table on each row? And that table is RankOfArea, filtered by whatever is in current row of the [Line] column?