Forum Discussion
Solved
Getting Single Value for a single key, while applying lookup
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 on...
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.
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.