OR DAX Formula with nested Search

[Anonymous]

Hi Experts

I have the following search formula which works fine and returns the correct result, i want to slightly change the formula so to have OR in the current measure

so the end result could be either

IF(SEARCH("compontentdissociation",'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],1,1000)<>1000,18

OR

IF(SEARCH("dissociation",'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],1,1000)<>1000,18

and the out put result as 18.

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my test, you also could get your desired output without using OR function. Please refer to the formula below.

Column 2 =
IF (
    SEARCH (
        "aaa",
        'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],
        1,
        1000
    ) <> 1000,
    18,
    IF (
        SEARCH (
            "bbb",
            'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],
            1,
            1000
        ) <> 1000,
        18
    )
)

Here is the output.

If you really want to use OR function, you could try this below.

Column =
OR (
    IF (
        SEARCH (
            "aaa",
            'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],
            1,
            1000
        ) <> 1000,
        18
    ),
    IF (
        SEARCH (
            "bbb",
            'njrew_k_prmry_bicon_outcm'[INDREV_SUMMARYREVISIONREASONS],
            1,
            1000
        ) <> 1000,
        18
    )
)

Best Regards,

Cherry

[Anonymous]

many thanks cheery works prefectly....