How to return a measure based on the index value and column name in a table ?

[Neo_Lyu]

Hi all,

I got the following table...

I want to know how to extract the cell value like CX-11 or 5 based on the LNG_MODEL_SEQUENCE = 1 and column name is STR_MODEL_CODE. The return can be a one cell table or a measure. 

Thanks for the help!

[Seward12533 · Accepted solution]

Measure
Model code for seq1 = CALCULATE(FIRSTNONBLANK(table[STR_MODEL_Code]),table(LNG_MODEL_SEQUENCE]=1)
For a single cell table
Model code for seq1 = CALCULATE(VALUES(table[STR_MODEL_Code]),table(LNG_MODEL_SEQUENCE]=1)

[Neo_Lyu]

Hi, thanks for the reply! It doesn't work somehow and gives the following warnings.

For measure

For table

Please give me further hits on this, Thanks!

[Neo_Lyu]

Just switch the expression and it works 🙂