Filtering using text found in a column

Try this:

Try both && as shown below and also try > || instead of &&

SEARCH("Incoming Payments" && "Outgoing Payments", Table [Line Memo])

Search DAX function | Text functions in Power BI - Power BI Docs

Hi Anonymous ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR tmp =
    FILTER (
        ALL ( 'Table' ),
        AND (
            OR (
                CONTAINSSTRING ( [Line Memo], "Incoming payment" ),
                CONTAINSSTRING ( [Line Memo], "Outgoing payment" )
            ),
            [Date] <= DATE ( 2022, 12, 31 )
        )
    )
RETURN
    SUMX ( tmp, [price] )

3. add a card visual with measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.