Forum Discussion
Dax Measure to get specific text value
- 6 years ago
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
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 🙂
thanks 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.
- Fowmy6 years ago
Super User
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 🙂
- joshua19906 years ago
Post Prodigy
I have a table where I have for each area a description like provided in the first post.
Then I have a matrix visual in the top of my view/ report where I would like to display one specific for the corresponding area.
Like the above, I would like to get the text where Area = B.
But I don't want to filter that within the visual. I would like to filter that in a measure like:
FILTER ( Area = "B") or so
- Fowmy6 years ago
Super User