Getting Single Value for a single key, while applying lookup

[jay_patel]

Hello everyone,

Here I am using alternate of Lookupvalue Function in power bi for getting Condition value from "MGPSL table", but there is two diff values for every single key,But I am geeting only single values for every single Key in "Charge Back Table". Also mentioning the Dax I have used for getting Condition-value. Also attaching images for the same.This is the Single value I am getting in Charge Back TableThis is what i actually want.

"Condition Value =
CALCULATE (
FIRSTNONBLANK ( Query1[ConditionValue], 1 ),
FILTER ( ALLSELECTED( Query1 ), Query1[key] = 'Charge Back'[NewKey] )
)"

[jay_patel]

This is working for one column but when i am trying for another table not working.

[amitchandak · Accepted solution]

@jay_patel ,

Try like

Condition Value =
var _1 = 'Charge Back'[NewKey]
return
CALCULATE (
FIRSTNONBLANK ( Query1[ConditionValue], 1 ),
FILTER ( Query1 , Query1[key] =_1 )
)

if this did not work

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.