Forum Discussion

fjones0409's avatar
fjones0409
Regular Visitor
6 years ago
Solved

Dax filtering for text value

Hi,   I have a table where 1 column just has data of type 'text', it is essentially a description colulmn. I am trying to use a dax measure in which i can return this text, when i filter by another...
Need Help
  • az38's avatar
    az38
    6 years ago

    hi fjones0409 

    for example, FIRSTNONBLANK()

    Desc = calculate(FIRSTNONBLANK(Table3[YourTextColumn], 1), filter(Table3,Table3[Scenario]= "something") )
az38's avatar
az38
Community Champion
6 years ago

hi fjones0409 

for example, FIRSTNONBLANK()

Desc = calculate(FIRSTNONBLANK(Table3[YourTextColumn], 1), filter(Table3,Table3[Scenario]= "something") )