Forum Discussion

Tumeski's avatar
Tumeski
New Member
8 years ago
Solved

DAX CONTAINS() Help with weird data I have

Hello,   I thought I would post my own post about this so I can explain the problem well enough. I have tried to look around to find a solution but no luck so far.   First I explain what I discov...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Tumeski,

     

    If you want do some contains related check, I'd like to suggest you use IN keyword with ALLSELECTED function.

    Sample:

    Billed =
IF (
    SELECTEDVALUE ( 'Orders'[ID] ) IN ALLSELECTED ( 'Bills'[OrderNum] );
    TRUE ();
    FALSE ()
)

    BTW, current dax  functions not support regular expression.

     

    Regards,

    Xiaoxin Sheng

Tumeski's avatar
Tumeski
New Member
8 years ago

Hey Anonymous,

 

Thank you for your reply. This DAX seems to do the trick. In C# Contains() understands to find it inside the string, but yeah I quess only IN is available to do this in DAX world.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Tumeski,

 

>>This DAX seems to do the trick. In C# Contains() understands to find it inside the string, but yeah I quess only IN is available to do this in DAX world.

For search text itself, I'd like to suggest you use search and find function.

DAX Fridays! #30: SEARCH vs FIND

 

Regards,

Xiaoxin Sheng