Forum Discussion
Post ProdigyDax Measure to get specific text value
Hello everyone!
I have a table like this:
| Area | Description |
| A | Mounting Production Area ... |
| B | ... |
| C | ... |
| D | ... |
Now, I am looking for a measure that shows me the text for Area = "B".
I need to display this in a matrix/ table. Just this sentence.
How can I solve that?
With concatenate?
How about this one?
Description for B = CALCULATE(MIN(Table[Description]), Table[Area] = "B")
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
8 Replies
- Fowmy
Super User
joshua1990
Can you show me how your matrix displays now? or what do you need in Column and Row and the value?________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
joshua1990thanks for your reply Fowmy :
For now, it looks like how I need it.
But I have filtered this matrix.
I would like not to filter. I would like to filter within the measure.
- Fowmy
joshua1990
Not clear enough, provide a clear explanation with example.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
waeltkenHelper I
Hey y'all - when I run this text lookup based on filter conditions as a calculated field witihin a table this code returns blank for all rows, even though each row has Position ID and Position Min Dates. Any idea under what conditions it would return blanks? No error message. Any way to triage? The Change Reason column is text
PositionMinReasonCode =VAR VPosition = PositionsDateRange[Position ID]RETURNCALCULATE(MIN(PositionsDateRange[changeReason (Picklist Label)]),PositionsDateRange[Effective Date] = PositionsDateRange[PositionMinDate],PositionsDateRange[Position ID] = VPosition)Regards,
Henrik
