Sum values by description that contains a common part of a string

[gianmarco]

Dear Friends,

I have the following table:

Description	Value
Apple One	3
Orange One	8
Apple Two	4
Orange Two	10

I have to sum those values which contains "Two" in the description.

How can one achieve that without using a lot of CALCULATE formulas?

Thanks

[selimovd · Accepted solution]

Hey @gianmarco ,

I think the best approach is without any CALCULATE at all 😉

Try that one:

Sum contains Two =
SUMX(
    myTable,
    IF(
        CONTAINSSTRING( myTable[Description], "two" ),
        myTable[Value]
    )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[CNENFRNL · Accepted solution]

Sum TWO = 
CALCULATE(
    SUM( 'Table'[Value] ),
    CONTAINSSTRING( 'Table'[Description], "TWO" )
)

[selimovd · Accepted solution]

Hey @gianmarco ,

I think the best approach is without any CALCULATE at all 😉

Try that one:

Sum contains Two =
SUMX(
    myTable,
    IF(
        CONTAINSSTRING( myTable[Description], "two" ),
        myTable[Value]
    )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[gianmarco]

Dear @selimovd

thank you so much! Both of your formulas solve my issue! I'm gonna accept @CNENFRNL's solution as he replied me earlier. Anyway, again, thank you a lot!

[selimovd]

Hey @gianmarco ,

you can also accept multiple posts as solution if they work for you 😉

But I'm happy you found a result for your problem.

Have a great weekend

Denis