DAX Syntax to fix

[Anonymous]

Experts, someone pls help me to fix the below DAX which is erroring out.

Thanks,

Bala

[Anonymous]

Thanks Amit for your quick response, Not able to the .pbix file for your reference. Please help me to fix the same with Syntax in the below for creating the column.

x Match - dp = IF((SEARCH("pass", Query1[Complaint Notes],,0)>0) ||

SEARCH("dp", Query1[Complaint Notes],,0)>0 ||

Query1[Complaint Amount]=75.12 &&

SEARCH("sdp", Query1[Complaint Notes],,0)=0, "dp", BLANK())

[SpartaBI]

@Anonymous try this one sec:

x Match - dp = IF((SEARCH("pass", Query1[Complaint Notes],,0)>0) ||

SEARCH("dp", Query1[Complaint Notes],,0)>0 ||

Query1[Complaint Amount]=75.12 &&

SEARCH("sdp", Query1[Complaint Notes],,0)=0, "dp", "")

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Thanks for your quick reply, Tried creating the same in new column but still it trows the error. pls help.

Should I create the column or Measure, If Measure How I can convert the text column it will consider?

[Anonymous]

Hi @Anonymous ,

The formula should be a calculated column and there should be no problem with the formula itself.

Please check these two columns for empty strings (""), you can replace and delete these values in Power Query.

Or you can check them and then execute the formula:

x Match - dp1 = 
IF (
    (
        NOT (
            'Query1'[Complaint Notes] = BLANK ()
                || 'Query1'[Complaint Notes] = ""
        )
    )
        && ( SEARCH ( "pass", Query1[Complaint Notes],, 0 ) > 0 )
        || SEARCH ( "dp", Query1[Complaint Notes],, 0 ) > 0
        || Query1[Complaint Amount] = 75.12
            && SEARCH ( "sdp", Query1[Complaint Notes],, 0 ) = 0,
    "dp",
    BLANK()
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Anonymous , seems fine in the screenshot. Can you share the formula in text format to check

Can you share a sample pbix after removing sensitive data.