Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Hope someone can help
best regards severin
Solved! Go to Solution.
@Severindj Please try this as a measure
TotalResponses = CALCULATE(SUM(MultiLkpTest[Response]),FILTER(ALL(MultiLkpTest),MultiLkpTest[Text]="Test1"))
Proud to be a PBI Community Champion
TotalResponses = CALCULATE(SUM(Response[ResponseValue]),FILTER(ALL(Question),Question[QuestionName]="Test1"))
Proud to be a PBI Community Champion
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks for reply. My tables are related by ID. There are multiple values in the 'finansiel række' collum in the question table.
Proud to be a PBI Community Champion
Hopefully this makes sense.
There are probably question dublicates, and therefore I need to sum them all up. they are related through id.
TotalResponses = CALCULATE(SUM(Response[ResponseValue]),FILTER(ALL(Question),Question[QuestionName]="Test1"))
Proud to be a PBI Community Champion
@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 ?
Proud to be a PBI Community Champion
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.
@Severindj Please try this as a measure
TotalResponses = CALCULATE(SUM(MultiLkpTest[Response]),FILTER(ALL(MultiLkpTest),MultiLkpTest[Text]="Test1"))
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |