lookup value bytext in another table

[Severindj]

dear forum 

I'm seeking to return 'Svar' number by a text measure in another table. 

The data looks like this: 


I want to find values in response collum when the the textvalue is "Omsætning i t.kr." in the 'finansiel række' collum in the question table.

  preferably it can be made as a measure. 

been trying the lookupfuction: 

Omsætning = LOOKUPVALUE(Response[Svar];Question[Finansiel række];"Omsætning i t.kr.")

does not display anything though. Perhabs because there are duplicates?

Hope someone can help

best regards severin

[PattemManohar · Accepted solution]

@Severindj Please try this as a measure

TotalResponses = CALCULATE(SUM(MultiLkpTest[Response]),FILTER(ALL(MultiLkpTest),MultiLkpTest[Text]="Test1"))

Sample DataOutput

[edhans]

LOOKUPVALUE() will return an error if there are multiple records found where the the results column has different values. Your tables also need to be related.

See the documentation with an example. 

[Severindj]

Thanks for reply. My tables are related by ID. There are multiple values in the 'finansiel række' collum  in the question table. 

[PattemManohar]

Please post the sample test data and expected output to understand your requirement in detail

[Severindj]

Hopefully this makes sense. 

There are probably question dublicates, and therefore I need to sum them all up. they are related through id. 

[PattemManohar · Accepted solution]

@Severindj 

TotalResponses = CALCULATE(SUM(Response[ResponseValue]),FILTER(ALL(Question),Question[QuestionName]="Test1"))

QuestionResponseRelationshipOutput

[PattemManohar]

@Severindj  Are you trying as a calculated column or measure ? Also, if there are multiple responses for that particular question then what you want to do ?

[Severindj]

Dear @PattemManohar I'm trying as a measure. If there are multiple responses, which I know there is, I want to sum them all up. Hopefully it's understandable. 

[PattemManohar · Accepted solution]

@Severindj Please try this as a measure

TotalResponses = CALCULATE(SUM(MultiLkpTest[Response]),FILTER(ALL(MultiLkpTest),MultiLkpTest[Text]="Test1"))

Sample DataOutput

[Severindj]

It worked @PattemManohar ! Thank you so much, you're a star!