Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Search text using multiple parameters

Hello -    I wonder if anyone can spot the problem with my dax query?    I am trying to search within a text using multiple parameters - The parameters are "Text search 1" ,"Text Search 2" and "T...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    You may try the following measure to see if it helps.

    Casenote mention count =
VAR s1 =
    MAX ( 'Text Search'[Text Search] )
VAR s2 =
    MAX ( 'Text Search 2'[Text Search 2] )
VAR s3 =
    MAX ( 'Text Search 3'[Text Search 3] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'All Casenotes'[CN Record ID] ),
        FILTER (
            'All Casenotes',
            CONTAINSSTRINGEXACT ( [Casenote text], s1 )
                || CONTAINSSTRINGEXACT ( [Casenote text], s2 )
                || CONTAINSSTRINGEXACT ( [Casenote text], s3 )
        )
    )

     

    Best Regards

    Allan

     

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

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

Anonymous,

 

Try this measure:

 

Casenote mention count = 
VAR vCasenote =
    MAX ( 'All Casenotes'[Casenote text] )
VAR vText1 =
    SUMX (
        'Text Search',
        SEARCH ( vCasenote, 'Text Search'[Text Search], 1, 0 )
    )
VAR vText2 =
    SUMX (
        'Text Search 2',
        SEARCH ( vCasenote, 'Text Search 2'[Text Search 2], 1, 0 )
    )
VAR vText3 =
    SUMX (
        'Text Search 3',
        SEARCH ( vCasenote, 'Text Search 3'[Text Search 3], 1, 0 )
    )
VAR vResult =
    IF (
        vText1 > 0
            || vText2 > 0
            || vText3 > 0,
        DISTINCTCOUNT ( 'All Casenotes'[CN Record ID] )
    )
RETURN
    vResult

 

For the AND version, replace "||" with "&&".