Forum Discussion

CLANG10's avatar
CLANG10
Icon for Helper I rankHelper I
3 years ago
Solved

Problem using sumx() with containsstring

Hi,     I am using CONTAINSSTRING to look for a specific text in a column, however i can't find the table/column, so i try using SUMX in the expression to be able to locate the column. An error occu...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi CLANG10 ,

    try this measure

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

     

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
3 years ago

CLANG10 

Need to see some datapoint to explain the solution better

  • CLANG10's avatar
    CLANG10
    Icon for Helper I rankHelper I
    3 years ago

    Hi,

       This is a section of my table, what i want is to find specific text in column "DISPLAY_ID" (E.G. if it contain DATA_UK, to return UK or DATA_USA, to return USA in a new column)...the problem is i can't write the table or column in my expression. Thanks in advance