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

Anonymous's avatar
Anonymous
Not applicable
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