Creating new column filtered by string

[ekarpowicz]

Hello all,

Pretty new to PowerBI and so far I have been loving it. Could anyone help me with an expression that doesn't seem to be working?

Here it is:

PatColl = CALCULATE(sum('Deposits'[DepositAmt]), FILTER('Deposits',[PayDesc] = "Cash Payment - Thank You" || [PayDesc] =  "Check Payment - Thank You" || [PayDesc] =  "Carecredit Payment - Thank You" || [PayDesc] =  "Credit Card Payment - Thank You"))

I'm trying to make a new column that will be showing me a sum of payments with a particular string in their description. Currently, it doesn't output anything at all.. just blank cells. I suppose trying to do this by a "payment type ID" might be cleaner but I'm trying this for sake of time right now. What could I possibly be doing wrong? The strings I'm trying to grab are accurate..

Hope I didn't break any forum rules! Looking forward to learning and creating more.

Thanks everyone!

Eric

[v-yulgu-msft]

Hi @ekarpowicz,

Please try this:

PatColl =
CALCULATE (
    SUM ( 'Deposits'[DepositAmt] ),
    FILTER (
        ALLSELECTED ( 'Deposits' ),
        [PayDesc] = "Cash Payment - Thank You"
            || [PayDesc] = "Check Payment - Thank You"
            || [PayDesc] = "Carecredit Payment - Thank You"
            || [PayDesc] = "Credit Card Payment - Thank You"
    )
)

For more advice, please share some dummy data and desired output as mentioned in this blog.

Best regards,

Yuliana Gu