How to create a measure that give a specific value from a table, based on a condition

[jct999]

Hello

I have a table in my model that contains parameters (i.e : (key, value)):
The table has 2 columns :

- ParamName : Name of the parameter (string)

- ParamValue : Value of the parameter (may be string, integer, date)

How can I create measure that returns the ParamValue based on a given ParamName ?

I tried that, but it does not work :

Measure =FIRSTNONBLANK(PARAM[ParamValue ];PARAM[ParamName ]="TheNameOfTheParameter")

Thanks

[dedelman_clng · Accepted solution]

Hi @jct999  - 

You can use LOOKUPVALUE for this:

Measure = 
var __PN = SELECTEDVALUE(PARAM[ParamName])
RETURN
LOOKUPVALUE ( PARAM[ParamValue], PARAM[ParanName], __PN )

Hope this helps

David