Forum Discussion
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...
Measure = IF(MAX('Table'[Column]) = X,[1.acu.a Value],BLANK())
Assumes 1.acu.a is a measure.
Greg_Deckler
Community Champion
Community ChampionMeasure = IF(MAX('Table'[Column]) = X,[1.acu.a Value],BLANK())
Assumes 1.acu.a is a measure.
Thanks Greg_Deckler
That works, why? I never would think to use MAX on an evaluation of a String.
- Greg_DecklerThink of using MAX and MIN on a string like "last" and "first".