Forum Discussion
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 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] )
)"
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.
2 Replies
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.
This is working for one column but when i am trying for another table not working.
