Forum Discussion
lookup value bytext in another table
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 "...
Anonymous Please try this as a measure
TotalResponses = CALCULATE(SUM(MultiLkpTest[Response]),FILTER(ALL(MultiLkpTest),MultiLkpTest[Text]="Test1"))
Sample DataOutput
Anonymous
TotalResponses = CALCULATE(SUM(Response[ResponseValue]),FILTER(ALL(Question),Question[QuestionName]="Test1"))
QuestionResponseRelationshipOutput
PattemManohar
Community Champion
Community ChampionPlease post the sample test data and expected output to understand your requirement in detail
Hopefully this makes sense.
There are probably question dublicates, and therefore I need to sum them all up. they are related through id.
- PattemManohar
Anonymous
TotalResponses = CALCULATE(SUM(Response[ResponseValue]),FILTER(ALL(Question),Question[QuestionName]="Test1"))
QuestionResponseRelationshipOutput