Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Dax 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 Are...
Need Help
  • mahoneypat's avatar
    mahoneypat
    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

waeltken's avatar
waeltken
Icon for Helper I rankHelper I
4 years ago

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]

RETURN

CALCULATE(
    MIN(PositionsDateRange[changeReason (Picklist Label)]),
    PositionsDateRange[Effective Date] = PositionsDateRange[PositionMinDate],
    PositionsDateRange[Position ID] = VPosition
)

 

Regards,

 

 

Henrik