Index | Name | Value 1 | ABC | 123 2 | DEF | 456 3 | GHI | 789
I want to extract the Name out of Index = 2. So basic, and yet so complicated.
This is my code:
Measure :=
VAR CalculatedTable = ....
RETURN
CALCULATE(MAX('CalculatedTable'[Name]),
FILTER('CalculatedTable', 'CalculatedTable'[Index] = 2))This doesn't work, and also, instead of MAX, also tried with VALUES and LOOKUPVALUE, but none works.