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.