Get value from a table where condition meets

[webportal]

My CalculatedTable contains 3 rows and 3 columns, like:

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.

[harshnathani]

Hi @webportal ,

CALCULATE(MAX('CalculatedTable'[Name]),'Index' = 2)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button) 

[webportal]

@harshnathani 

Thanks, but I get the error:

It's not possible to use the table variable 'CalculatedTable' in the actual context because it is expected a base table.

[az38 · Accepted solution]

Hi @webportal 

try MAXX

return 
calculate(maxx(FILTER(CalculatedTable, [Index] = 2), [Name]))

[webportal]

OK, that one works!

But, why don't the ohters?
MAX, VALUES, LOOKUPVALUE?

[webportal]

DISTINCT also works, btw.