Lookupvalue or an other formula to search a value with a measure ?

[Anonymous]

Hello / Good morning,

My question is very sample. I own a table result which contain several column . Each column come from to a column or a measure.

In my case I own a result from measure . If the result = 1 , I want process to a "lookupvalue" with column and measure parameters.

My formula that I want complete :

My_value_wanted =
var okay= [Measure_okay]
return
if([Measure_okay]=1; condition true > lookupvalue ; condition false > keep empty )

blue : column text format

red : measure result date format

My key to search in an other table :  'mytable'[offer_code]&"_"&'mytable'[offer_state]&"_"&value([Date_from_measure_result])

In a second table if value exist return a key and associeted value .

I must use lookupvalue or fitler system ?

Thanks for the help.

[v-diye-msft]

Hi @Anonymous 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[Anonymous · Accepted solution]

Hello,

After severals hours to search a solution, I have tried this formula :

step 1 :

key_borne max =

var affiche = [M_affichable]

var valnum=value([M_Date Max garde])

return

if(affiche=1;maxx(bi2n_dmt_rec;bi2n_dmt_rec[offer_code]&"_"&bi2n_dmt_rec[offer_state]&"_"&[M_Date Max garde]);"")

step 2 :

recherche parc fin =

var valsearch = [key_borne max]

return

LOOKUPVALUE(T_union_decale_current[state_park_current_day];T_union_decale_current[key_offercode_state_date];valsearch)