Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row Context and return a single value from Column

I'm struggling with evaluating a row context to determine if the specific row I'm in meets certain criteria. I get the error that basically indicates to me that I'm returning a table of values (I'm a...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Measure = IF(MAX('Table'[Column]) = X,[1.acu.a Value],BLANK())

     

    Assumes 1.acu.a is a measure.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Greg_Deckler 

That works, why? I never would think to use MAX on an evaluation of a String.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Think of using MAX and MIN on a string like "last" and "first".