Forum Discussion
Post ProdigyDax Measure to get specific text value
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
Post ProdigyI 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
Super User- joshua1990
- mahoneypat
Microsoft Employee
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