Can't use SUM with VALUE function

[Khurram_Ahmed]

I am trying to use a measure to first check if a column has numeric values and only then sum those values.

Here is my code:

IF(
    ISERROR( VALUE( SUM( 'Spreadsheet Cell'[Value] ) ) ),
    BLANK( ),
    VALUE( SUM( 'Spreadsheet Cell'[Value] ) )
)

However, it is giving this error:

The above formula works if I replace SUM with MAX (but only gives the max value, I am interested in getting the SUM).

Any help with this is appreciated. Thanks!

[smpa01 · Accepted solution]

Can you try this @Khurram_Ahmed 

MEASURE =
CALCULATE (
    SUMX (
        ADDCOLUMNS ( 'Table', "@double", CONVERT ( 'Table'[Column1], DOUBLE ) ),
        [@double]
    ),
    FILTER (
        VALUES ( 'Table'[Column1] ),
        NOT ( ISERROR ( CONVERT ( 'Table'[Column1], DOUBLE ) ) )
    )
)

[Khurram_Ahmed]

Hi, thanks a lot for helping with this. This is working!

[_AAndrade]

Hi @Khurram_Ahmed,

Please try this:

IF(
    ISNUMBER( SUM( 'Spreadsheet Cell'[Value] ) ),
    SUM( 'Spreadsheet Cell'[Value] ),
    BLANK()
)