Calcualte(sum giving an error

[Anonymous]

Hello Community,

i am trying to create a calculated column and i am getting below error.Can i get suggestion? Thanks

Error Message"The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."

delete after use = CALCULATE(SUM([RAW Valid Months]),'03- Contracts'[Sales Org]="AMERICAS"&'04-Software '[P Identifier]='04-Software '[RAW Unique])

[jthomson]

Try using a comma/semicolon depending on your localisation instead of &, if it's still coming up you may need to make some sort of custom column to compare the two 04-Software columns to see if they're equal and then use that in your column

[Anonymous]

thank you so much for your suggestion.I have tried with , but i am getting the same error.

[AlB · Accepted solution]

Hi @Anonymous

Perhaps like this?

delete after use =
CALCULATE (
    SUM ( [RAW Valid Months] ),
    FILTER (
        ALL ( '03- Contracts'[Sales Org] ),
        '03- Contracts'[Sales Org] = "AMERICAS"
    ),
    FILTER (
        '04-Software ',
        '04-Software '[P Identifier] = '04-Software '[RAW Unique]
    )
)

[Anonymous]

Thank you so much AIB.

[AlB]

@Anonymous

No worries.

If you're interested, in this article you can read why your first approach was not working.