Forum Discussion

jessenewold's avatar
jessenewold
Frequent Visitor
4 years ago
Solved

Dax using IF and Contains

Hello,  I've created the below to replace the name of the terminal ID i.e. CAD01-2006 with Dispatch etc.  I have hundreds of terminals.  I want to be able to find all of the terminals that have "we...
  • ERD's avatar
    ERD
    4 years ago

    jessenewold ,

    You can try this approach:

    Measure = 
IF (
    CONTAINSSTRING ( SELECTEDVALUE ( T4[TERMINAL ID] ), "$" ) = TRUE (),
    "MOBILE",
    SELECTEDVALUE ( T4[TERMINAL ID] )
)

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
4 years ago

jessenewold ,

You can try this approach:

Measure = 
IF (
    CONTAINSSTRING ( SELECTEDVALUE ( T4[TERMINAL ID] ), "$" ) = TRUE (),
    "MOBILE",
    SELECTEDVALUE ( T4[TERMINAL ID] )
)

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

jessenewold's avatar
jessenewold
Frequent Visitor
4 years ago

Thank you so very much - this is exactly what I was looking for.