Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calcualte(sum giving an error

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])

Need Help
  • AlB's avatar
    AlB
    7 years ago

    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]
    )
)

     

5 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        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]
    )
)